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 …

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 Da…

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	2410	8 January 2020
Change Time Format string value General	11	3079	20 November 2020
Convert weatherapi.com time_epoch field to InfluxDB timestamp General	16	383	2 October 2022
Converting data from CSV file General	3	507	7 December 2020
RFC3339 to Unix Timestamp General	12	2230	27 May 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