# | Date | Forum | Type | Thread | Post |
---|---|---|---|---|---|
8 | 20 Nov 2012 @ 09:10 PST | Database | Reply | Get 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 ... |
7 | 30 Oct 2012 @ 12:54 PDT | Tools | Reply | SQL Assistant truncating View definition | Please try to access the requesttext column in dbc.tabletext, then you will see the ddl of those large view. |
6 | 30 Oct 2012 @ 12:19 PDT | Database | Topic | How 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... |
5 | 26 Mar 2012 @ 10:59 PDT | General | Reply | SQL 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; |
4 | 21 Oct 2009 @ 10:36 PDT | Connectivity | Reply | Teradata access clients for the Mac | I think it's for Mac Intel only, not for Mac PPC. |
3 | 21 Oct 2009 @ 10:28 PDT | Database | Reply | select * from database_name.table_name | Try this: database database_name; select * from table_name; |
2 | 17 Mar 2009 @ 12:48 PDT | Database | Reply | How to skip the header row in the fastload script | FYR....RECORD 2;DEFINE ...... |
1 | 18 Apr 2007 @ 10:30 PDT | Database | Reply | FREE copy of a Fully functional Teradata Database Demo CD | FYR...Demonstration Software for Teradata Warehouse 8.1 http://www.teradata.com/t/page/156360/index.html |