0
0
Question Learning by_passion · Jul 15, 2024

i need ISO timezone date format

#InterSystems IRIS for Health #VSCode

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 (0)0
Log in or sign up to continue

Comments

Learning by_passion  Jul 15, 2024 to Luis Angel Pérez Ramos

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

0