Archives of the TeradataForum

Message Posted: Thu, 14 Mar 2002 @ 19:10:04 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I have tried the below query and it works. I hope this helps you.

Select
databasename,
tablename,
CreateTimeStamp (date),
CreateTimestamp (time(0))
from DBC.Tables
where tablename = 'table_name' ;

--Shridhar Suvarna

	<Prev	Next>		<<First	<Prev	Next>	Last>>