#DateForumTypeThreadPost
1012 Nov 2014 @ 12:59 PSTDatabaseReplyHow to reduce skew factor on stage tables with NoPI?Hi All,   I have table having 75 rows with UPI. Still the skew factor is 77. What can be the reason for this high skew factor and how possibly can I reduce this?   Thanks, Shardul
928 Oct 2014 @ 12:53 PDTDatabaseReplySubquery in Case StatementWhen we use a case statement in select list, the subquery must return one and only one value. Imagine a query returning values more than a field can take. You can select something like MAX(field) f...
817 Oct 2014 @ 07:17 PDTDatabaseReplyHow to convert JAN 1, 2007 12:00:00 AM into timestamp format 'YYYY-MM-DDBHH:MI:SS' ???Hi Dieter,   We are using TD14. What if the source field is in SQL Server and conatains something like Feb 14 2012  6:55AM   And this has to be loaded in a TIMESTAMP(6) field i...
708 Oct 2014 @ 08:44 PDTDatabaseReplyTimestamp for the previous dayThanks Raja :) Silly me. Thanks again -Shardul
608 Oct 2014 @ 08:23 PDTDatabaseTopicTimestamp for the previous dayHi All, I have a requirement which goes like this: My timestamp(6) field, which is, say, myTimeValue contains: 2014-10-08 10:14:51.210000 Now, if I wanted to change this to the previous day...
524 Sep 2014 @ 03:14 PDTDatabaseReplyTimestamp formatYeah Raja, the first idea, of conacatenating with ':00:00.000000', I had it earlier :) Finally I am going with something like below: SELECT CAST(CAST(myDateDTS as DATE format 'YY...
424 Sep 2014 @ 02:50 PDTDatabaseReplyTimestamp formatHi Raja, Thanks for your input. My field, say myDateTS, is TIMESTAMP(6). So, I guess we would not be able to cast it to TIMESTAMP(0). We can then cast it to date and then again to timestamp(0) an...
324 Sep 2014 @ 12:35 PDTDatabaseTopicTimestamp formatI have a timestamp(6) field which holds values like: 2011-09-08 15:10:00.000000 I need to get this timestamp as: 2011-09-08 15:00:00.000000 I want to avoid SUBSTR and alike fucntions and do this ...
223 Sep 2014 @ 01:52 PDTDatabaseReplyHow do use DateDiff in Teradata, in my SQL, it works but in Teradata giving me some kind of errorHi Dieter, How would we transform the following expression to Teradata equivalent: CASE       WHEN DATEADD(hour, DATEDIFF(hour, 0, a.BeginDTS), 0) = DATEADD(hour, DATE...
116 Jan 2014 @ 12:16 PSTConnectivityTopicConnection Profile for Vertica in Teradata SQL AssistantHi, I have been connecting to Vertica using Teradata SQL Assistant 12 (which requires an ODBC driver). However, in case of Teradata SQL Assistant 13.11 (Java Edition), I am unable to create a conn...

Pages