GUI datetime formatting
Posted: Wed 12 Feb 2020 22:04
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"
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"