#DateForumTypeThreadPost
817 Jul 2013 @ 11:21 PDTDatabaseTopicSQL for Current Year Starting and ending datesAll, I am looking for a SQL that gives the current year starting and ending dates. i.e.., 01/01/2013 & 12/31/2013
717 Jul 2013 @ 09:36 PDTDatabaseTopicSQL for last year starting and ending datesHi all, I am trying to get SQL for last year starting and ending dates. Ex : 01/01/2012 & 12/31/2012.
629 Oct 2012 @ 02:01 PDTDatabaseTopichow to write Year(Date(Days({fn CURDATE()})-32)) in TeradataHi, Can anyone help me in converting this : Year(Date(Days({fn CURDATE()})-32)) in teradata Thanks !
525 Oct 2012 @ 02:56 PDTDatabaseTopicHow to write (CURRENT DATE - 1 YEAR) in teradata?Can anyone help here how to write/convert  this (CURRENT DATE - 1 YEAR) in teradata.   Thanks  
417 Apr 2012 @ 09:16 PDTGeneralTopicCurrent year starting month and current year ending month Hi, Can anyone let me know the SQL for current year begining month and current year ending month. This should give us jan and dec when we run the query
329 Mar 2012 @ 09:34 PDTGeneralTopicSQl for current period and Previous period   Is there any SQL that contains the current period which should be current month begin date and current month end date and similarly for the previous period which should be previou...
229 Mar 2012 @ 09:32 PDTDatabaseTopicSQl for current period Is there any SQL that contains the current period which should be current month begin date and current month end date and similarly for the previous period which should be previous month begin d...
126 Mar 2012 @ 01:18 PDTGeneralTopicSQL for the current month begin date and end date Hello all,   I am new to the terdadata database and looking for some help regarding sql for the current month begin date and current month end date