I have a Node.js server running as an API server for a service I'm working on for a company.
The MySQL server it connects to stores dates for when an event starts, insertion works perfectly and you can see the correct date from MySQL Workbench and the command line tool. However, when I go to retrieve the date column from Node.js, the output is a day behind for the timezone I'm currently in even though it's the same timezone as the server and MySQL server.
Any ideas?
I also wrote a small script that I ran on the server to get example output:
The start date is a day behind, the UTC date is right on (it should be July 28th, which is what MySQL Workbench displays, and what was originally inserted).