NOW() is indepedent of timezones

CodeFoodPixels / node-promise-mysql

A wrapper for mysqljs/mysql that wraps function calls with Bluebird promises.

MIT License

338 stars 63 forks source link

NOW() is indepedent of timezones #41

Closed samueltangz closed 7 years ago

samueltangz commented 7 years ago

NOW() function is independent of timezones. For instance, if I run "SELECT NOW();" at the same time, it returns "Thu Jan 05 2017 13:52:12 GMT+0800 (HKT)" and "Thu Jan 05 2017 13:52:12 GMT+0000 (UTC)" if I have supplied different timezones. Is it specific to promise-mysql? Thanks!

CodeFoodPixels commented 7 years ago

Nope, that's all to do with mysql itself