Community & Support
Learn
Marketplace
Menu
Menu
Home
›
Discussions
›
Community Q&A
How to filter date when use read Database
kurama
New Altair Community Member
Feb 21, 2021
Updated
Nov 5, 2024
by
Jocelyn
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
Find more posts tagged with
AI Studio
All Replies
Accepted Answers
Sort by:
Sort by
Oldest
▾
1 - 2 of 2
↑
1
↑
BalazsBaranyRM
New Altair Community Member
Accepted Answer
Feb 21, 2021
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
New Altair Community Member
OP
Feb 21, 2021
Thank you very much
Sort by:
Sort by
Oldest
▾
1 - 1 of 1
↑
1
↑
BalazsBaranyRM
New Altair Community Member
Accepted Answer
Feb 21, 2021
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
View in context
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
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