MySQL Forums
Forum List  »  Connector/Node.js

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

Hi Lawrence,

are you starting the server with any specific timezone-related option? I've just tried running a server in different timezones and running something like

session.sql('select now()').execute()

yields exactly what I expect, the system time. As I mentioned before, there is no conversion performed by the connector. However, that does not mean something wrong might be happening for a specific corner case.

That's why I'm asking for a specific test to reproduce the issue. Or at least, a specific column data type, the value of that column, and how it was inserted.


Thanks

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.