MySQL Bugs: #116346: selecting from table with datetime or timestamp does not show time portion

Bug #116346	selecting from table with datetime or timestamp does not show time portion
Submitted:	13 Oct 2024 0:37	Modified:	14 Oct 2024 6:40
Reporter:	David Bunge	Email Updates:
Status:	Verified	Impact on me:	None
Category:	Shell VSCode Extension	Severity:	S3 (Non-critical)
Version:	1.16.4	OS:	Windows
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When I run "select * from <table>", the results table shows only the date portion of a column that is of datatype "datetime" or "timestamp", when it should show the date and time.

How to repeat:
Create table with a column with datetime or timestamp data type.
Insert record and populate the column
Select from the table

Hello David Bunge,

Thank you for the report and feedback.
Verified as described.

regards,
Umesh