JavaScript (Node.js) -- retrieving date from MySQL column is a day behind

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:

  • Event name: Aidan's Birthday
  • Start date: Sat Jul 27 2013 19:00:00 GMT-0500 (CDT)
  • Milliseconds: 1374969600000
  • UTC: Sun, 28 Jul 2013 00:00:00 GMT
  • Day of month: 27
  • ISO String: 2013-07-28T00:00:00.000Z
  • Locale string: Sat Jul 27 2013 19:00:00 GMT-0500 (CDT)

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).