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

kuramakurama Member Posts: 4 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

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 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

Sign In or Register to comment.