setting the timezone

[Randall Meeker]

My local dev machine (that I'm running sails on) is in central time zone. But I want to develop my sails app as if it were running in UTC / +00:00.

I'm running MySql with Sails. I have MySql server set as UTC at the default, and when I query the DB directly i get my correct date / time (in UTC). 

However when sails queries the DB, sails / waterlines attempts to transform it into UTC (but it already is). so my UTC value of 

"2008-07-06 00:30:00" is transformed into "2008-07-06 05:30:00"

When I set my system timezone on my machine to UTC, then sails output all the data correctly. But then I have to work off of a machine in the wrong timezone.

So how to I set this up so it will work correctly?

I have looked at these issues to no avail:

https://github.com/balderdashy/sails/issues/969 and 

http://stackoverflow.com/questions/24104725/how-to-set-local-timezone-in-sails-js-or-express-js

and I have also read where your supposed to put this somewhere -- process.env.TZ = 'UTC'

[Randall Meeker]

Ok, I found a setting in the MySql options file to change timezone to UTC, its default is local.

This can be set in the connections.js 

  mySqlDb: {

    adapter : 'sails-mysql',

    host    : 'localhost',

    user    : 'xxxx',

    password: 'xxxx',

    database: 'xxxxx', 

    schema: true,

    timezone: 'utc'

  },