#DateForumTypeThreadPost
1316 Mar 2016 @ 10:11 PDTGeneralTopicSubtracting times when multiple column value changesHi,   Ticket_ID Name Person_Indicator time Transaction Type Transaction time when indicator is A1 111 AAA 1 12:05:00 a1 5 111 ...
1216 Mar 2016 @ 08:18 PDTGeneralTopicSelect data from char position to the nextI have a column which is a text like this- Col = '/a/bbb/cc/aaa/ddd' I want to output only bbb. That is everything between 2nd "/" and 3rd "/". How should I g...
1116 Mar 2016 @ 08:07 PDTDatabaseReplyHow to make substring with the second or third occurrence of a charaterI have a text in column that looks like this-  /a/bbb/cc/dddd   I want to display bbb as my output. That is the text between 2nd "/" and 3rd "/" . How should I go a...
1015 Jan 2016 @ 09:06 PSTGeneralReplyRemoving decimals from datetime in Teradata SELECT prod_tm TIMESTAMP(0) (FORMAT 'MM/DD/YYBHH:MI:SSBT') AS Col1  
915 Jan 2016 @ 09:06 PSTGeneralReplyRemoving decimals from datetime in Teradata@Glass : this did not work. My column name is prod_tm.    SELECT prod_tm TIMESTAMP(0) (FORMAT 'MM/DD'YYBHH:MI:SSBT') AS Col1 This did not work! Could you please suggest s...
815 Jan 2016 @ 07:59 PSTGeneralTopicRemoving decimals from datetime in TeradataOne of my datetime columns is in format - mm/dd/yyyy hh:mm:ss.000000   How do I get rid of the zeroes? I want my final result in three columns showing-   Col1- mm/dd/yyyy hh:mm:...
706 Aug 2015 @ 02:54 PDTGeneralTopicChanging time format and adding to dateHello, I have time in format HH:MM and date in format mm/dd/yyyy. I want COL1 with time formated as HH:MM:SS and COL2 a combination of COL1 and date in format MM/DD/YYYY HH:MM:SS. Also, then I ne...
616 Jul 2015 @ 02:10 PDTGeneralReplyChanging display/format of Teradata SQL Assistant ResultIt is needed to enter into another software. Thank you so much. I think that helps . And, answers my questions.
516 Jul 2015 @ 12:16 PDTGeneralReplyChanging display/format of Teradata SQL Assistant ResultAll right. This worked. How do I however do it for numeric values? For something like "27" which is in COL4 and "abc22" which is in COL5. I tried the following stateme...
416 Jul 2015 @ 10:17 PDTGeneralReplyChanging display/format of Teradata SQL Assistant ResultI can briefly show you what the statement looks like-- SELECT LPAD(COL1, 4, ' ' ) || LPAD (COL2, 5, ' ' ) AS COL3 FROM ( ...... .....) With this statement now I am getting err...
316 Jul 2015 @ 08:56 PDTGeneralReplyChanging display/format of Teradata SQL Assistant ResultI also want to use LPAD function. But, when I write the query, it says invalid expression. I want to do something like this-- ABC 3234 YYY AB   222   ZZZ QQQ 3333 WWW So, es...
216 Jun 2015 @ 10:27 PDTGeneralReplyChanging display/format of Teradata SQL Assistant ResultThanks. This helps.
115 Jun 2015 @ 07:37 PDTGeneralTopicChanging display/format of Teradata SQL Assistant ResultHi, I am using Teradata SQL Assistant v14.10 and want to manipulate the way result is displayed when I run my query. I want to do the following things- When exporting result in TXT file, I...