#DateForumTypeThreadPost
820 Nov 2012 @ 09:10 PSTDatabaseReplyGet current week number from the date in current year.  Hello,   I guess that: the 'week_of_year' in 'sys_calendar.calendar' table is what you want. ex: sel week_of_year from sys_calendar.calendar ...
730 Oct 2012 @ 12:54 PDTToolsReplySQL Assistant truncating View definitionPlease try to access the requesttext column in dbc.tabletext, then you will see the ddl of those large view.
630 Oct 2012 @ 12:19 PDTDatabaseTopicHow does "interval 'n' month" work? Hi All,   The result of running "sel add_months(date '2011-03-31',-1);" will be : "2011-02-28". But the result fo running "sel date '2011-03-31...
526 Mar 2012 @ 10:59 PDTGeneralReplySQL for the current month begin date and end date FYR... select date ,cast(date/100*100+1 as date) ,add_months(cast(date/100*100+1 as date),1)-1;
421 Oct 2009 @ 10:36 PDTConnectivityReplyTeradata access clients for the MacI think it's for Mac Intel only, not for Mac PPC.
321 Oct 2009 @ 10:28 PDTDatabaseReplyselect * from database_name.table_nameTry this: database database_name; select * from table_name;
217 Mar 2009 @ 12:48 PDTDatabaseReplyHow to skip the header row in the fastload scriptFYR....RECORD 2;DEFINE ......
118 Apr 2007 @ 10:30 PDTDatabaseReplyFREE copy of a Fully functional Teradata Database Demo CDFYR...Demonstration Software for Teradata Warehouse 8.1 http://www.teradata.com/t/page/156360/index.html