Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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

Image: https://us.v-cdn.net/6030995/uploads/editor/uz/65lbodgn6mt2.jpg

always come this error

Image: https://us.v-cdn.net/6030995/uploads/editor/mj/796by45utucc.jpg

sorry i'm really newbie at this

Find more posts tagged with

AI Studio

Accepted answers

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

All comments

BalazsBaranyRM

kurama

Thank you very much