%JSONImport & TimeStamp

Question

Question

Matjaz Murko · Jul 4, 2022

#InterSystems IRIS

Hi.

Why is %TimeStamp property not correctly imported with %JSONImport method - it doesn't take into account the time zone?

Regards,
Matjaž

Product version: IRIS 2022.1

Discussion (5)1

Log in or sign up to continue

Robert Cemper · Aug 27, 2022

from:
https://docs.jsonata.org/date-time#:~:text=JSON%20does%20not%20have%20a,%3A45%3A00.000Z%22%20%7D

for ISO 8301
#1) your source has to be a %TimeStamp aka. ODBC format
#2) it requires a LogicalToXSD() transformation.

> write ##class(%Library.TimeStamp).LogicalToXSD($ZDT($Now(),3,,4)) 2022-08-27T22:54:48.8953Z

But there is no defined Standard.

0 0

score 0 · Answer 1 · 2022-08-24T08:48:52-04:00

Time zone is an environment level variable. The intersystems data server response is at the application level, so likely returning gmt is correct. The application can adjust based on the environment (geolocation).

score 0 · Answer 2 · 2022-08-27T12:34:32-04:00

Matjaz Murko · Aug 27, 2022

Isn't time format in JSON standardized?

0 0

score 0 · Answer 3 · 2022-08-27T14:48:25-04:00

Eduard Lebedyuk · Aug 27, 2022

Please consider providing an example?

0 0

score 1 · Answer 4 · 2022-08-29T08:57:45-04:00

I did some upgrade to newer version of IRIS and it looks like it working now as expected.

Tnx!

Regards,
Matjaž.