Hey all,
Quick question:
If a dashboard user in the UK (BST) creates an event starting at 10am (BST), will it be stored as BST or UTC?
Thanks in advance,
Dave
Below the screenshot of Directus DateTime and Timestamp fields against a postgres database at GMT+2.
DateTime translates to timestamp without time zone on postgres with GMT+2 value.
Timestamp translates to timestamp with time zone on postgres with UTC value BUT without timezone offset
I guess Timestamp is not really writing it correctly, because it misses the offset. At least for postgres. Not sure tho, if Directus can be configured to use a specific timezone. Maybe someone can clarify that.
Also other DB systems may behave different, so better check directly on your database what is actually stored.
EDIT:
To note, both values are rendered correctly in GMT+2 inside Data Studio. So i guess Directus is compensating the missing timezone offset by just converting it from UTC to the local timezone of the server.
(All above tested on the builtin Directus Datetime interface)