Written by

Sales Engineer at InterSystems

STAFF

Question Sylvain Guilbaud · Aug 23, 2023

Does LOAD DATA provide in a future version an option to indicate a date/datetime format other than 'yyyy-mm-dd hh:mm:ss'?

#InterSystems IRIS #InterSystems IRIS for Health #Data Import and Export #JDBC #SQL #Tools

Is it planned that LOAD DATA takes into account several DATE/DATETIME formats with, for example, a parameter indicating the format used in the source data?

example :

LOAD DATA .../...
USING
{
  "from": {
    "file": {
       "dateformat": "DD/MM/YYYY"
    }
  }
}

Product version: IRIS 2023.2

$ZV: IRIS for UNIX (Ubuntu Server LTS for ARM64 Containers) 2023.2 (Build 227U) Mon Jul 31 2023 17:43:25 EDT

Discussion (3)0

Add reply

Comments

Sylvain Guilbaud · Jan 5, 2024

Added to Ideas

0 0

Robert Cemper · Jan 5, 2024

Bonsoir Sylvain!
Are you looking for something similar to this;

Property MonJour As%String 
     [ InitialExpression = "31/12/1840" ];Property Jour As%Date [ InitialExpression = 0,
  SqlComputeCode = {set {*}= $ZDH({MonJour},4) },
  SqlComputed, SqlComputeOnChange = MonJour ];

(Multiline just for readability)

0 0

Sylvain Guilbaud Jan 9, 2024 to Robert Cemper

Bonjour Robert,
I only wish to be able to ingest data using LOAD DATA with the choice regarding the format of the date in the data source. Currently the date is only supposed to be expressed in the source in the ODBC|TimeStamp format YYYY-MM-DD.

0 0