Re: Dates being returned in the wrong timezone

[Lawrence Marigold]

OK well I've solved this for my purposes by storing all dates in the DB as timestamps, as that means they are stored as UTC and translated to the servers timezone automatically.

I then set the server's timezone for the session to UTC (so the dates are sent to the connector still in UTC) like so:

await session.sql('SET time_zone = '+00:00'').execute();

That way the dates that node receives are in UTC and it automatically converts them to the correct timezone for the server.

Any other clients are unaffected and therefore I can use workbench with the timestamps shown in the correct timezone.

Thanks for all your help.