having issues with timezone
i have a simple defaultNow timestamp saving, but the db is giving the timestamp another hour behind?
eg. saving data at 17:00 in bst, should be 16:00 in utc, but the db is giving 15:00
18 Replies
Project ID:
3fad4fec-c497-4ecf-a107-dbd12bc4e047
3fad4fec-c497-4ecf-a107-dbd12bc4e047
as per standard, the deployments operate on utc time
yeah im pretty baffled
![No description](https://cdn.answeroverflow.com/1158443118601965578/image.png)
![No description](https://cdn.answeroverflow.com/1158443180216295444/image.png)
these are the latest items being saved right now
which is -2, instead of -1
-2 from what? is that not a utc timestamp?
it seems to be an hour behind utc
utc right now is 16:40
but data is being saved at 15:40
have you somehow set a different timezone?
Where on the db?
Or in the data I’m saving?
ok interesting
this is on localhost - correct
![No description](https://cdn.answeroverflow.com/1158447728213381231/image.png)
this is deployed - incorrect
![No description](https://cdn.answeroverflow.com/1158447803425632336/image.png)
missing an hour
no clue what language this is, but instead of being ambiguous, specifically save the time as utc, then when reading the date back from the database convert to the desired time zone for display purposes only