I am new to Teradata and having hard time on doing queries with date in the where clause. Apparently it does not work similarly as for example in Oracle SQL.
I am querying a view. There is column called Register_Date and the format [DATE].
When I select * the date looks like this for example: 15.1.2018.
But when I put that into a where clause it gives me error: SELECT Failed  A character string failed conversion to a numeric value.
I have tried to put (Date) in front and afterwards but it keeps giving me the same error.
where Register_Date = '15.1.2018'
Could someone help me with this one?
There's only one recommended date format using a Standard SQL date literal:
The date returned by SQL Assistant is formatted locally, you should change it to YYYY-MM-DD:
Tools > Options > Data Format > Display dates in this format