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

Question

Question

Sylvain Guilbaud · Aug 23, 2023

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

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

Go to the original post written by @Sylvain Guilbaud

Discussion (3)1

Log in or sign up to continue

Sylvain Guilbaud · Jan 5

Added to Ideas

0 0

score 0 · Answer 1 · 2024-01-05T14:20:28-05:00

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)

score 0 · Answer 2 · 2024-01-09T03:45:07-05:00

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.