Teradata Forums / Teradata / Training / Difference Between CURRENT_DATE() and DATE / Latest PostsInstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 03:14:20 GMT20RE: Difference Between CURRENT_DATE() and DATEhttp://www.teradata.com/teradataforum/Topic5763-13-1.aspxBe 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.)<br><br>-pt<br><br>Mon, 05 Feb 2007 15:11:59 GMTtextures2RE: Difference Between CURRENT_DATE() and DATEhttp://www.teradata.com/teradataforum/Topic5763-13-1.aspxya you can use..<br><br>regds,<br>sachinThu, 01 Feb 2007 04:47:12 GMTsachinp17RE: Difference Between CURRENT_DATE() and DATEhttp://www.teradata.com/teradataforum/Topic5763-13-1.aspxCan current_date be used in an equation<br><br>where tbl1.host_date = current_date -1Wed, 15 Nov 2006 17:08:33 GMTScott at SabreRE: Difference Between CURRENT_DATE() and DATEhttp://www.teradata.com/teradataforum/Topic5763-13-1.aspxCURRENT_DATE [no parentheses] is ANSI SQL and should be used for new development. DATE is old Teradata-only syntax retained for backward compatibility. Wed, 08 Nov 2006 11:51:59 GMTFred PluebellDifference Between CURRENT_DATE() and DATEhttp://www.teradata.com/teradataforum/Topic5763-13-1.aspxHi all,<br><br><br>Difference Between CURRENT_DATE() and DATEWed, 08 Nov 2006 09:28:53 GMTsrini.dw