How to convert date in "YYYY-MM-DDTHH:MM:SSZ" format to "yyyymmddhhmmss" format?

Question

Question

#Caché #Ensemble #Global Masters #Health Connect #HealthShare #InterSystems IRIS

I'm trying to convert date - 2023-09-28T20:35:41Z to BST/GMT format. I tried with $ZDT($ZDTH("2023-09-28T20:35:41Z",-2),8,1) but it's giving the output as '19700101 01:33:43' and looks link the date format in $ZDTH specified is wrong. Any inputs or solution would be appreciated.

Discussion (2)1

Log in or sign up to continue

score 0 · Answer 1 · 2024-09-02T14:29:05-04:00

Robert Cemper · 12 hr ago

set time="2023-09-28T20:35:41Z"
write $TRANSLATE(tine,"-:TZ")

20230928203541

0 0

score 0 · Answer 2 · 2024-09-03T02:39:31-04:00

Samyuktha Chaudhary · 46 min ago

Thanks for the response Robert. But this wouldn't account for the 1 hour time diff during day light savings.

0 0