The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

How to filter date when use read Database

kurama
kurama Member Posts: 4 image Learner I
in Help
Hello, 
please kindly help me , 

i use read database (my databse is teradata)
when i build query 


always come this error


sorry i'm really newbie at this

Best Answer

  • BalazsBarany
    BalazsBarany Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 image Unicorn
    Solution Accepted
    Hi @kurama,

    the query you're using doesn't seem to work in Teradata because of different date format settings.

    I found this: https://docs.teradata.com/r/S0Fw2AVH8ff3MDA0wDOHlQ/ryoeKJsEr22NqKahaktP5g

    Basically, you need to find out which date format the database expects for the attribute you're querying, and pass your date in that format.

    Regards,
    Balázs

Answers

Categories