Convert Date Time to Unix time

[mitchdennis]

Hi all

I have a message output being read from a CSV file that is in this format "GPS Time: "Sun Dec 01 08:50:14 PST 2019".Does anybody know how to convert it to a Unix time.
Thanks
Dennis Mitchell

[Colin]

In your other post you showed it already converted
GPS Time: 1577775035485
Since you already have an active thread discussing how to format the data for influx it would really be better to keep it all in one thread.

[mitchdennis]

Hi Colin

I thought I had it converted using the change node using the time stamp output but this is the current time not the time from my data.

[Colin]

Let's continue this back in the original thread.

Need help inputting CSV data from OBD2 into influx from Chevy bolt

I would like to store all the values with the GPS time stamp for the time So for example Battery Level GPS Time: 1577775035485 !Battery Level Displayed(%): 72.94117737 Battery voltage GPS Time: 1577775035485 !MG Voltage(V): 372.98001099 Ect. All values are from a CSV logfile from the OBD2 reader. The way I have it right now I get a message object for each row in the CSV file with GPS Time being the first line outputted. I need to modify the message to a format that is correct for influ…

[Nikolay]

I have an array from a database with UNIX/epoch time format and I use this to convert all the timestamps in the array:

var i;
for (i = 0; i <msg.payload.length; i++) {

var now = new Date(msg.payload[i].TIMESTAMP).toLocaleString("en-GB");
msg.payload[i].TIMESTAMP = now;

}

return msg;

So new Date().toLocaleString("en-GB"); works for me.