#DateForumTypeThreadPost
412 Feb 2010 @ 11:09 PSTDatabaseReplyExtraction of time from timestamp!solved the problem - it was in sql assistant. the same query runs fine in bteq =))
312 Feb 2010 @ 06:36 PSTDatabaseTopicExtraction of time from timestamp!From the TD user manual, i got this as an example of timestamp to time conversion: SELECT CAST(cast('1997-12-31 23:59:59' as timestamp(5)) AS TIME(5) WITH TIME ZONE); But why the time zone? h...
219 Jan 2010 @ 11:50 PSTToolsTopicTPT, Oracle, ODBC, load operatorHi All,I'm trying to use TPT to load data directly from an Oracle table to Teradata. BUT.. I'm having a little problem with numeric data types.In oracle, I have a lot of different NUMBER(10,0) and ...
119 Jan 2010 @ 08:39 PSTToolsTopicTPT load from ORACLE to TeradataHi All, I'm trying to use TPT to load data directly from an Oracle table to Teradata. BUT.. I'm having a little problem with numeric data types. In oracle, I have a lot of different NUMBER(10,0) ...