felixge/node-mysql — pull request #313 by dresende (2012-10-31 09:43:37+00:00)
Title: Timezone support

Default timezone: **local**
Advised timezone: **Z** (UTC)

Configure:

```js
var mysql = require("mysql");
var con = mysql.createConnection("mysql://root@localhost/test?timezone=Z");
```

To define other timezones, use the format `+00:00` or `-00:00` (you can also omit the colon).

Usage:

You always pass a normal Date object in the local timezone (you know.. normal). `mysql` will convert it to the timezone you define and save that to the database. Likewise, when reading from the database, dates will be considered as being in that timezone and will be converted to local ones.