Difference Between CURRENT

Difference Between CURRENT_DATE() and DATE

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Difference Between CURRENT_DATE() and DATE

Rate Topic

Display Mode

Topic Options

Author

Message

srini.dw

Posted 11/8/2006 9:28:53 AM

Forum Newbie

Group: Forum Members
Last Login: 11/27/2006 6:35:00 AM
Posts: 1, Visits: 1

Hi all,

Difference Between CURRENT_DATE() and DATE

Post #5763

Fred Pluebell

Posted 11/8/2006 11:51:59 AM

Supreme Being

Group: PAC and SFT Members
Last Login: Yesterday @ 10:56:35 AM
Posts: 298, Visits: 363

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

Post #5767

Scott at Sabre

Posted 11/15/2006 5:08:33 PM

Forum Newbie

Group: Forum Members
Last Login: 2/5/2007 3:16:00 PM
Posts: 1, Visits: 1

Can current_date be used in an equation

where tbl1.host_date = current_date -1

Post #5865

sachinp17

Posted 2/1/2007 4:47:12 AM

Forum Guru

Group: Forum Members
Last Login: 8/20/2008 2:31:00 AM
Posts: 53, Visits: 10

ya you can use..

regds,
sachin

Post #6443

textures2

Posted 2/5/2007 3:11:59 PM

Junior Member

Group: Forum Members
Last Login: 3/27/2007 12:06:00 PM
Posts: 12, Visits: 1

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

Peter T. Bense - pbense@ebay.com
Sr. Performance Engineer, eBay
Teradata Certified Master V2R5

Post #6467

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 2 ( 2 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 4:23am