MySQL Forums
Forum List  »  Connector/Node.js

Re: Dates being returned in the wrong timezone
Posted by: Rui Quelhas
Date: November 26, 2020 04:12AM

You are starting the server with the timezone set to '+01:00', so that kind of makes sense.

If your system timezone is 10h53m, the server will return 11h53m, since "now()" returns a datetime format with the timezone you specified. "unix_timestamp()", on the other hand, returns a UTC timestamp (not a datetime) to the client, which means it simply returns the UTC value (10h53) in milliseconds.

Am I missing something?

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.