#DateForumTypeThreadPost
409 Oct 2012 @ 12:10 PDTToolsReplyBTEQ data format question/DATE format issueTested on -> TERADATA EXPRESS DATABASE 12.0 (Windows"XP 32 bit) Somethign like this? with tt(TMS_TMP,TMS_TMP1) as ( select '9999-12-31 23:59:59' tms_tmp,...
308 Oct 2012 @ 12:41 PDTToolsReplyInsert select in MloadGuys,  I would like to know one thing. Generally, in other DB - DDL statement is faster than any other DML statment due to it's logging mechanism. So, if op's table can be dropped &a...
206 Oct 2012 @ 11:49 PDTUDAReplyTeraData vs OracleConsidering Oracle & TD, I've noticed one significant difference in terms of PL/SQL coding point of view. When in Oracle, Programmers are encourage to write PL/SQL such as procedure, funct...
106 Oct 2012 @ 11:12 PDTTeradata ApplicationsReplyQuery to convert Decimal(15) to date format 'yyyy-mm-dd'I don't think this is a complete information you have provided for any of the volunteers. No sample data, no version info. It is always easy to put your Teradata version info along with some i...