#DateForumTypeThreadPost
518 Aug 2016 @ 09:41 PDTToolsTopicMonth days !!!Hi, Could any one explain this code logic, DAY(DATEADD(ms,-2,DATEADD(MONTH, DATEDIFF(MONTH,0,CURRENT_DATE.DAY)+1,0))) and provide me alternate code in tera data...   Thanks..
418 Aug 2016 @ 09:34 PDTTeradata DebuggerReplyFetching the last date of the current Quarter !!! Hi Dieter,            Yeah its working for the end of current quarter. Thank you. The code for fetching the current quarter's first date is working fine.  If...
318 Aug 2016 @ 09:12 PDTUDAReplyCONVERT and DATEDIFF in TeradataHii Dieter,   Thanks. How can i handle this convert (SMALLDATETIME, {fn CURDATE()}--> epoch time format in teradata.??
218 Aug 2016 @ 06:53 PDTUDAReplyCONVERT and DATEDIFF in TeradataHi, For this SQL Query select DATEDIFF(DAY,'2016-08-20', convert (SMALLDATETIME, {fn CURDATE()})).. I need to achieve this in Tera data. Since datediff is problem to work with here in ter...
118 Aug 2016 @ 02:34 PDTTeradata DebuggerTopicFetching the last date of the current Quarter !!! Fetching the last date of the current Quarter !!!    This query fetches the fist date of the current Quarter-->>select TRUNC(ADD_MONTHS(CURRENT_DATE,-1),'Q'). Need to kno...