InterSystems Ideas
We love hearing from our users. Tell us what you want to see next and upvote ideas from the community.
* Bugs and troubleshooting should as usual go through InterSystems support.
Add a new idea Subscribe
Status Implemented
Categories InterSystems IRIS
Created by Sylvain Guilbaud
Created on Jan 5, 2024

RELATED IDEAS

Date format in LOAD DATA to indicate a date/datetime format other than 'yyyy-mm-dd hh:mm:ss'

Provide an option in LOAD DATA to indicate a date/datetime format other than 'yyyy-mm-dd hh:mm:ss'

i.e :

LOAD DATA .../...
USING
{
  "from": {
    "file": {
       "dateformat": "DD/MM/YYYY"
    }
  }
}
  • ADMIN RESPONSE
    Oct 28, 2024

    Thank you for submitting the idea.

    This idea was implemented by InterSystems.

  • Post comment
  • Admin
    Benjamin De Boe
    Reply
    |     Oct 28, 2024

    With IRIS 2024.2, we introduced support for using expressions in the VALUES clause of the LOAD DATA command. There are some (largely obvious) restrictions such as that these ought to be basic scalar SQL functions or literals, meaning you can incorporate TO_DATE() or similar to achieve the right date value or formatting to make the ingestion work directly from your file.