GUI datetime formatting

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
Post Reply
dburtsev
Posts: 8
Joined: Wed 18 Jan 2017 19:57

GUI datetime formatting

Post by dburtsev » 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"

alexa
Devart Team
Posts: 2962
Joined: Fri 24 Jun 2011 14:17

Re: GUI datetime formatting

Post by alexa » Thu 13 Feb 2020 12:53

You may be interested in the following thread https://forums.devart.com/viewtopic.php?f=51&t=39753

dburtsev
Posts: 8
Joined: Wed 18 Jan 2017 19:57

Re: GUI datetime formatting

Post by dburtsev » Thu 13 Feb 2020 21:11

Thank you, it works. You can close this ticket.
Dmitriy

alexa
Devart Team
Posts: 2962
Joined: Fri 24 Jun 2011 14:17

Re: GUI datetime formatting

Post by alexa » Fri 21 Feb 2020 19:45

Thank you for the reply.

Please let us know if any questions arise.

Post Reply