Question
· Jul 15

i need ISO timezone date format

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.

Product version: IRIS 2024.1
Discussion (2)2
Log in or sign up to continue