#DateForumTypeThreadPost
322 Apr 2006 @ 08:55 PDTDatabaseReplyCollect Stats ReportTry :select * from dbc.multicolumnstats where tablename='XX' and databasename='XX'Thanks.
210 Mar 2006 @ 08:43 PSTDatabaseReplyTimestamp format on teradata retrievalHi , 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...
110 Feb 2006 @ 05:04 PSTDatabaseReplyMonth differenceselect (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...