Postgresql timestamp or date10/23/2023 To get the date for a certain time zone, apply AT TIME ZONE first. The same point in time translates to the next day in parts of Europe, when it is past 4 p.m. ![]() ![]() You still get the date for the current time zone, which agrees with the display of the timestamp. If you extract a date from type timestamp with time zone ( timestamptz for short), the time zone offset is "applied" first. ![]() The day in the output will be the same as in the display of the timestamp value. If you extract a date from type timestamp, you get the date for the current time zone.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |