Skip to main content

​
What Timezone is the Hosted Database in?

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 savings To verify this you can run: 
select creation_time as PST,
convert_timezone(your_time_zone, creation_time) as your_time_zone
from appointment
where creation_time is not null
order by creation_time desc;
You will see anything created after Daylight Savings time will be adjusted.