Documentation Index
Fetch the complete documentation index at: https://help.elationhealth.com/llms.txt
Use this file to discover all available pages before exploring further.
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.