Question Carl (booz Alle... · Jun 25, 2024 SQL DatePart Not Working With ISO 8601 Formatted Date & Time Given a properly formatted ISO 8601 date time of 2024-06-23T06:03:00Z using SQL DatePart results in an error: [SQLCODE: <-400>:<Fatal error occurred>] [%msg: <Invalid input to DATEPART() function: datepart='ss', datetime value='2024-06-23T06:03:00Z')>] If I remove the trailing Z (for Zulu / UTC time) and leave the T, DatePart works fine. #SQL #InterSystems IRIS for Health 0 2 0 133
Question Carl (booz Alle... · Mar 5, 2024 Output Dynamic Object JSON Data To A CSV File We have JSON type data in a Dynamic Object. Is there a simple way to export / dump that data to a delimited string or file? e.g. Results={"ClassA":{"ClassName":"ClassA","ACount":367191880,"BCount":367191880,"CurrentDiff":0,"PreviousDiff":0,"ReportDate":"2024-03-02 00:00:00"}"ClassB":{"ClassName":"ClassB","ACount":5352149227,"BCount":5352149227,"CurrentDiff":0,"PreviousDiff":0,"ReportDate":"2024-03-02 00:00:00"}} #CSV #JSON #Key Question #InterSystems IRIS #InterSystems IRIS for Health 0 6 0 358