The New York time is 5 PM
SELECT GETDATE(), CONVERT_TIMEZONE('America/New_York', GETDATE()), DATEADD(hrs, 9, TRUNC(GETDATE())), DATEADD(hrs, 18, TRUNC(GETDATE()))
getdate convert_timezone date_add date_add1
2020-02-12 10:01:26.000000 2020-02-12 05:01:26.000000 2020-02-12 09:00:00.000000 2020-02-12 06:00:00.000000
The same query output from HeidiSQL
"2020-02-12 22:03:21" "2020-02-12 17:03:21" "2020-02-12 09:00:00" "2020-02-12 18:00:00"
GUI datetime formatting
Re: GUI datetime formatting
You may be interested in the following thread https://forums.devart.com/viewtopic.php?f=51&t=39753
Re: GUI datetime formatting
Thank you, it works. You can close this ticket.
Dmitriy
Dmitriy
Re: GUI datetime formatting
Thank you for the reply.
Please let us know if any questions arise.
Please let us know if any questions arise.