0 - 2 of 2 tags for database functions

HI ,

I just tried the following in Teradata v13 enterprise version

sel case when current_date > 8/25/2012 then 'yes' else 'no' end as output

Today is the 24th of August . I get the output as 'yes' which is logically wrong. The statement works fine with dates <= current_date , but fails for future dates.

Hi All,

 

I have some idea of TRUNC for Date and Number in Oracle,but not in Teradata..How to use it in teradata...Can anyone explain....

     TRUNC(Column_Name)