Difference Between CURRENT_DATE() and DATE

Training

Difference Between CURRENT_DATE() and DATE

Hi all,

Difference Between CURRENT_DATE() and DATE
4 REPLIES
Teradata Employee

Re: Difference Between CURRENT_DATE() and DATE

CURRENT_DATE [no parentheses] is ANSI SQL and should be used for new development. DATE is old Teradata-only syntax retained for backward compatibility.

Re: Difference Between CURRENT_DATE() and DATE

Can current_date be used in an equation

where tbl1.host_date = current_date -1
Enthusiast

Re: Difference Between CURRENT_DATE() and DATE

ya you can use..

regds,
sachin
Enthusiast

Re: Difference Between CURRENT_DATE() and DATE

Be careful that you do not try to use these expressions on PPI tables. If so, the optimizer will not invoke partition eliminiation (at least in the current release.)

-pt