timestamp type error

[Alkarex]

Hello,
every things ok but....
I'd like to insert timestamp in my database, this the last value of my query, but I don't know why the format is changed as we can see in this capture:

Why the query convert the time in GMT ?

Originally posted by @FlorianBfr in #41 (comment)

[Alkarex]

This looks like because you are likely mislead by your debug output. You are sending a JavaScript DateTime object while you should be sending a string (in ISO format).

[FlorianBfr]

Just before I have a function where I convert the orignal timestamp in date :
var d = new Date (msg.payload.tst*1000);
newpayload.event_datetime = d;
msg.payload = newpayload;
return msg;

[Alkarex]

This is exactly what is wrong. You need to convert your date object to a string

[FlorianBfr]

When I convert the date in string the trouble is the same

[Alkarex]

As string, but in the correct format!
You need an ISO format

[FlorianBfr]

Ok I will try, thank

[FlorianBfr]

Yess ! You are very good !
Tank you very much. The good sentence is :
var d = new Date(msg.payload.tst*1000);
newpayload.event_datetime = d.toISOString();