Re: Dates being returned in the wrong timezone

[Lawrence Marigold]

Hi,

In that case I would seem to be stuck with either having the date out by an hour in the code, or seeing UTC dates when I do a query using the mysql client or workbench - or am I wrong about that?

I just tried using a timestamp column instead of datetime and strangely it's still adding an hour! The timestamp I get from workbench when I do

select max(updatedOn) from products

is 1606137696

In the javascript however with exactly the same code I get the js timestamp of 1606141296000, which divided by 1000 for the difference between js and unix timestamps is an hour later. It seems very odd that it actually changes the timestamp, as that should always be the same no matter the timezone?

Thanks - Lawrence