How to filter date when use read Database

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

Sign In or Register to comment.