| # | Date | Forum | Type | Thread | Post |
|---|
| 3 | 22 Apr 2006 @ 08:55 PDT | Database | Reply | Collect Stats Report | Try :select * from dbc.multicolumnstats where tablename='XX' and databasename='XX'Thanks. |
| 2 | 10 Mar 2006 @ 08:43 PST | Database | Reply | Timestamp format on teradata retrieval | Hi , Default timestamp format : yyyy-mm-dd hh:mm:sssel current_timestamp 2006-03-10 07:17:58.37So specify the desired format: as ex1:select '03/07/2006 12:49:29' as ts,cast(cast(ts as timestamp(0... |
| 1 | 10 Feb 2006 @ 05:04 PST | Database | Reply | Month difference | select (extract (year from '2006-03-22' )-extract(year from '2005-01-01'))*12 + extract (month from '2006-03-22') - extract (month from '2005-01-01')14 monthsselect (extract (year from '2006-0... |
|
|