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
Hi! @Learning by_passion
Take a look to this page of the official documentation:
https://docs.intersystems.com/iris20242/csp/docbook/DocBook.UI.Page.cls?...
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