nulls values about mysql HOT 4 CLOSED

Fixed in a107dc6

Let me know if it works for you.

from mysql.

Thanks, it works.

The type conversion (for datetime):
val = new Date (dbvalue + 'Z') ignores server timezone.

Ideally, I would like to specify a callback (plugin) for type casting.
For example, I don't want parseFloat for big decimals.

from mysql.

The type conversion (for datetime):
val = new Date (dbvalue + 'Z') ignores server timezone.

It assumes that your dates are stored as UTC+0. But I can see why this may not be the case. I guess it would be better to simply leave out the 'Z' as it is still possible to adjust the date/time offset afterwards, right?

Ideally, I would like to specify a callback (plugin) for type casting.
For example, I don't want parseFloat for big decimals.

Ok, I'm tracking this idea as #35. Not sure when I'll get to it so.

--fg

from mysql.

thank you,
I will store all datetimes on the server as UTC+0 and i will use UTC_TIMESTAMP() instead of NOW() for datetime operations.

from mysql.