The Timezone your data is in will be in Pacific Time with the exception of the appt_time column in the appointment table
Can we convert timezones to our time?
You can use the convert_timezone function however this will not persist in your database and will need to be ran every time.
Do you adjust date/times for daylight savings time?
Yes we do! Your timestamps will change with daylight savingsTo verify this you can run:
select creation_time as PST,convert_timezone(your_time_zone, creation_time) as your_time_zonefrom appointmentwhere creation_time is not nullorder by creation_time desc;
You will see anything created after Daylight Savings time will be adjusted.
Was this page helpful?
⌘I
Assistant
Responses are generated using AI and may contain mistakes.