SQL JSON_OBJECT

Question

Question

Matjaz Murko · Apr 30, 2022

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

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 0

score 0 · Answer 1 · 2022-05-03T05:31:43-04:00

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ž

score 0 · Answer 2 · 2022-05-03T10:37:11-04:00

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ž