Hi All,
I am trying to insert workflow time into timescaledb. The column defined as timestamptz. but for some reason, when i insert the format is changing and throwing error. Need help on this,
The time property on the initial payload is a JavaScript Date Object. You can pass that as an argument to either the Date/Time Node or the {{formatDate}} Handlebars helper to convert it to whichever format that column in your database expects. I’m assuming you do not actually want to store it as the stringified date but rather as a Unix timestamp or as an ISO string.