Skip to content
Coda Timezone Experiments
Share
Explore

Using Formulas

Basics
Seconds in a day
86400
Seconds in an hour
3600
Document TZ
Africa/Johannesburg
Document offset
2
Document offset in days
0.08333333333333333
Document offset in seconds
7200
User TZ
UTC
User offset:
0
User offset in days
0
User offset in seconds
0
Epoch
Epoch date
1/1/1970
Epoch date in days
25569
Epoch date in seconds
2209161600
Epoch date to number
25569
Epoch date to date time
1/1/1970 12:00 AM
Epoch date to time value
0
Deltas
Epoch Delta
-2209168800
UTC Delta
-2209176000
Local Delta
-2209176000
Current time
Current time in document time zone:
9/18/2021 12:15:32 AM
Current time in days
44457.01079688657
Current time in seconds
3841085732.851
Current time minus epoch offset
1631924132.8509998
Current time minus epoch and document offsets
1631916932.8509998
Current time into epoch
9/20/2091 2:15:32 AM
Current time into epoch minus epoch offset
9/18/2021 2:15:32 AM
Current time into epoch minus epoch and document offsets
9/18/2021 12:15:32 AM
Conclusion
Document Time
9/18/2021 12:15:32 AM
Document Time from Epoch
9/18/2021 12:15:32 AM
Document Time in UTC
9/17/2021 10:15:32 PM
Document Time in Local Time
9/17/2021 10:15:32 PM

Timezone Table with Formulas
0
When (Document Time)
UTC
Your Time
1
April 3, 2020, 2:30 AM
April 3, 2020, 12:30 AM
April 3, 2020, 12:30 AM
2
April 3, 2020, 6:28 AM
April 3, 2020, 4:28 AM
April 3, 2020, 4:28 AM
3
April 3, 2020, 6:41 AM
April 3, 2020, 4:41 AM
April 3, 2020, 4:41 AM
There are no rows in this table
3
Count


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.