InterSystems Ideas

Have an idea, suggestion, or something that doesn’t work as expected in InterSystems products or services? Share it here on the InterSystems Ideas Portal.

The Ideas Portal is where community members can propose improvements, report bugs, and help influence the product roadmap across InterSystems products and the overall developer experience. 22% of submitted ideas are implemented by InterSystems or members of the Developer Community.

💡 Ideas and bugs are both welcome, no matter how big or small. You can submit feature requests, usability improvements, workflow suggestions, and bug reports. Whether you’re an experienced expert or just getting started, your fresh perspective is valuable.

🛠️ About bugs and fixes. If you have access to InterSystems WRC, please submit bugs there for immediate action. Bug reports submitted through the Ideas Portal are reviewed and tracked, but do not guarantee immediate resolution.

Start by sharing what could be better - the community and our teams will help take it from there.

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
  • Benjamin De Boe
    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.

    Reply