#DateForumTypeThreadPost
906 Sep 2016 @ 07:02 PDTDatabaseReplyOLAP SQL - running count/total Below is the solution and answer is inspired from  Dieter Answer  from the link below   https://forums.teradata.com/forum/database/olap-function-csum-sum-with-reset-va...
831 Aug 2016 @ 08:03 PDTDatabaseReplyReplacing tableSAS work tables and Teradata Volatile tables are similar in a way that both exists only for Session.  SAS allows to replace tables if they already exist, Teradata does not. You need to do what...
731 Aug 2016 @ 07:56 PDTDatabaseReplySet multiple variable in one case statement Hi,  Code in SAS is a do loop. If you want to achive same thing then use 2 case statements, which is simple and easy solution. case when RFRL_SRC_CD = '039' then 1 end var_firs...
606 Jul 2016 @ 02:29 PDTDatabaseReplyregexp_similar '^.$' issuesJust one more update. We have TD14 and TD 15 on different servers and I did following query select case when regexp_similar('¥','^.$', 'i')=1     &...
505 Jul 2016 @ 07:05 PDTDatabaseTopicregexp_similar '^.$' issues Hi For data scrubbing I have lot of hard coded values in my code. I am trying to put those values in a table. One of the condition for this scrubbing is to find length of character and code ...
426 Jun 2016 @ 07:49 PDTDatabaseReplyunix timestamp with timezone to teradata timestampThanks Dieter
324 Jun 2016 @ 02:45 PDTDatabaseReplyunix timestamp with timezone to teradata timestampHi all Below code worked for me.   sel  TO_TIMESTAMP( CAST( ( 1466017810720 - 1466017810720 MOD 1000 ) / 1000 AS BIGINT)  ) + ( 1466017810720 MOD 1000 * INTERVAL '0...
224 Jun 2016 @ 02:08 PDTDatabaseTopicunix timestamp with timezone to teradata timestampHi all,  I have unix epcoh timestamp with timezone and it needs to be converted to teradata timestamp(6). I have tried to solve this by seeing old posts in teradata forums, but none...
131 Jul 2015 @ 06:14 PDTDatabaseReplyREGEXP_REPLACE does not replace all occurrences, even when setting occurence_arg=0This works though   select 'abcde12x34f5' as vat, REGEXP_REPLACE(VAT,'[^0-9]+','',1,0,'I')