i need ISO timezone date format

Question

Question

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)1

Log in or sign up to continue

score 0 · Answer 1 · 2024-07-15T01:53:54-04:00

Hi! @Learning by_passion
Take a look to this page of the official documentation:

score 0 · Answer 2 · 2024-07-15T07:22:35-04:00

This looks very time consuming and difficult job to find the exact function. if you know that can you please give me the syntax of this.

Set date = "20240501144800-0500"

convert this date into below format.

expected result -> 2024-05-01T16:49:00-05:00