How to filter date when use read Database

kurama

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

BalazsBaranyRM

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

BalazsBaranyRM

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

kurama

Thank you very much