nulls values

[gigirasu]

Hi,

NULLs values (dates/numbers/integers) are not properly handled.

Try:

select date_column from table where date_column is null;

In query.js :

row[field.name] = new Date(row[field.name]+'Z'); // row[field.name] is null !

[felixge]

Fixed in a107dc6

Let me know if it works for you.

[gigirasu]

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.

[felixge]

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

[gigirasu]

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.