Singlestat panel not displaying YYYY:MM:DD for todays date

Grafana
1

If the timestamp value is of recent time, singlestat panel is just displaying the hh:mm:ss. I am looking for the complete date format that I selected which is YYYY-MM-DD HH:mm:ss

Example: In my case I am selecting the current timestampsingelstat panel just shows HH:mm:ss which is what I am not expecting, how do even figure out which day that time belongs to? Attaching the screenshots for reference.

Selecting Current Time:

Screen Shot 2020-05-12 at 4.31.59 PM
Screen Shot 2020-05-12 at 4.31.59 PM2384×1106 156 KB

Selecting Yesterdays Time:

Screen Shot 2020-05-12 at 4.32.19 PM
Screen Shot 2020-05-12 at 4.32.19 PM2386×1104 161 KB

Grafana Server I am using: Grafana v6.5.2 (742d165)
Data source : MySql

2

There may be a better way but for MySQL data sources I just use the mysql date_format function something like:

select DATE_FORMAT(datetime, '%d/%m/%Y %H:%i')

3

Yes thats an option, but I wanted the time zone selected in Grafana to be effective.