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

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.

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.

Let's continue this back in the original thread. [image] Need help inputting CSV data from OBD2 into influx from Chevy bolt General 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…

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.

Node-RED

Node-RED Forum

Convert Date Time to Unix time

General

Colin 31 December 2019 22:43 4

Let's continue this back in the original thread.

Topic		Replies	Views
Need help inputting CSV data from OBD2 into influx from Chevy bolt General	23	2537	8 January 2020
Change Time Format string value General	10	3213	21 September 2020
Convert weatherapi.com time_epoch field to InfluxDB timestamp General	15	448	18 September 2022
Converting data from CSV file General	2	528	23 November 2020
RFC3339 to Unix Timestamp General	11	2319	28 March 2022

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Convert Date Time to Unix time

Related topics