I’m currently receiving data in Node-RED and simultaneously transferring it to Google Drive for storage. Everything is working fine, but I’m facing an issue with the time format. Node-RED is providing me with a 13-digit value that I can’t easily interpret to understand the date and time. I need help in converting this timestamp to a more readable format, including the day, month, year, and exact time (I know by clicking on Time I can change the format, however, it is just temporary).
I’ve already written Java code in a Function node to extract sensor data from Node-RED and transfer it to a Google Drive sheet, but I’m unsure how to write code to convert the timestamp into a human-readable format.