Question : This query: WITH RECURSIVE cte AS ( SELECT 0 n UNION ALL SELECT n + 1 FROM cte […]
Tag: timezone
Convert a DATETIME value using string Timezone Info?
Question : I have a column which has date, time, and timezone info like this: Sat, 20 Aug 2016 03:50:04 […]
Disable mysql_tzinfo_to_sql during MariaDB/MySQL installation
Question : MariaDB run in docker container hangs during initial startup while mysql_tzinfo_to_sql running because of the issue. I’ve disabled […]
How can I get the correct offset between UTC and local times for a date that is before or after DST?
Question : I currently use the following to get a local datetime from a UTC datetime: SET @offset = DateDiff(minute, […]
Postgres initdb with custom timezone directory
Question : How can I run Postgres initdb with a custom timezone folder? I’ve tried to use the -L flag […]
Creating a job scheduled based on a specific timezone
Question : I have an Oracle database hosted in Europe. I need to create a scheduled job in the database […]
Returning correct timezone offset from join
Question : Meeting table |MeetingID | Start | Timezone | LocalStartTime |13 | 2018-01-31 19:00:00 | (UTC+10:00)Melbourne | |23 | […]
MySQL timestamp timezone handling
Question : Does the timestamp data type represent an instant-in-time or a year-month-date-hour-minute-second value? An instant in time is a […]
Why do I see the timezone offset displayed in PgAdmin, for a timestamp with timezone
Question : I’m using PgAdmin 4 v6, and for some timestamp data with data type of timestamp with time zone, […]
Oddities with AT TIME ZONE and UTC offsets
Question : I don’t understand the difference between these two columns. America/Chicago timezone is UTC-6, so I expect both to […]