#DateForumTypeThreadPost
504 Apr 2006 @ 03:27 PDTDatabaseReplyHow to get tablenameI found it:select tablename from dbc.tables where database=your databaseThanks,Michael
404 Apr 2006 @ 11:54 PDTDatabaseTopicHow to get tablenameHi,What is the equivalent for select table_name from user_tables in Teradata database?Thanks,Michael
303 Apr 2006 @ 11:29 PDTDatabaseReply3706 Syntax error with select statementI figured it out.select (cast (current_timestamp) as date - col_a from ....Thanks,Michael
203 Apr 2006 @ 10:18 PDTDatabaseReply3706 Syntax error with select statementHi Dieter,Thanks for response , the datatype for col2 is timestamp and the col_A is an integer.I used your suggestion, and I'm getting a 5407 error code: Invalid operation on an ANSI Datetime or I...
131 Mar 2006 @ 04:04 PSTDatabaseTopic3706 Syntax error with select statementHi,I'm a newbie in teradata, I'm trying to use the following select statement that works in Oracle db, but it doesn't work in teradata. Would some one help me with the syntax.select * from table_a ...