![]() If no, you may want to visit the setting of timezone in your nf or your client for the session. Test with: SELECT now() ĭoes it display the same time as a clock on your wall? If yes (and the db server is running with correct time), the timezone setting of your current session agrees with your local time zone. Given that starts_at is a timestamp and the time on your server is set to the local time. Therefore, what you describe at the top of the question contradicts your example. 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 |