New post
Question
· 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'?

#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
Discussion (3)1
Log in or sign up to continue
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 ];
 
ObjectScript
ObjectScript

(Multiline just for readability)

 

0 0