0
322

Written by

Matjaz Murko
Follow
Question Matjaz Murko · Apr 30, 2022

SQL JSON_OBJECT

#InterSystems IRIS

Hi.

I'm trying to serialize property of type %TimeStamp in SQL statement with JSON_OBJECT, but I get a raw string instead of JSON DateTime format string. %JSONExport method on the same object works fine.

Any ideas?

Regards,
Matjaž

Product version: IRIS 2021.2
Discussion (3)1
Log in or sign up to continue

Comments

Matthew Waddingham · May 3, 2022

I've not tried in this specific combination but potentially wrapping the field in %External(Field) might give you the correct result.

0
Matjaz Murko  May 3, 2022 to Matthew Waddingham

Hi.

I've already tried it, but with no success. But I recently upgraded IRIS to the newest version and it works.

Tnx.

Regards,
Matjaž

0
Matjaz Murko  May 3, 2022 to Matthew Waddingham

Sorry, my mistake. JSON_OBJECT should parse %TimeStamp value to ISO 8601 format, but it doesn't. So my question is how to do it...

Regards,
Matjaž

0