Question
Matjaz Murko · Apr 30

SQL JSON_OBJECT

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
0
0 93
Discussion (3)1
Log in or sign up to continue

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

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ž

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ž