Hi Team,
This is very urgent can you please guide me to convert the date string to ISO format.
set date = "20240501144800-0500"
set result = $SYSTEM.SQL.Functions.TOTIMESTAMP(date, "YYYYMMDDHHMISS")
write result -> 2024-05-01T16:49:00:00+00:00
so here timezone is dropped off but i need that.
expected result -> 2024-05-01T16:49:00-05:00
Please help me here how i can convert in this format.