#DateForumTypeThreadPost
817 Sep 2014 @ 02:50 PDTGeneralReplyConvert calender date (YYYY-MM-DD) to julian dateJerico ... thanks a lot again ... found below query to work as expected.   select current_date (format 'yyyyddd') (char(7));
717 Sep 2014 @ 02:44 PDTGeneralReplyConvert calender date (YYYY-MM-DD) to julian dateHi Jerico, Thanks a lot for your input, however i didnt get the same result while executing the query. In fact the format appears as  2014-09-07 as mentioned below. Am i doing something wrong...
617 Sep 2014 @ 01:54 PDTGeneralTopicConvert calender date (YYYY-MM-DD) to julian dateHi All, Could you please help me with a query with which i can convert a date value (YYYY-MM-DD) in to julian date format YYYYDDD. Thanks Jaganna
521 Aug 2014 @ 07:12 PDTGeneralReplyIntroduce sequence number on Full row duplicates dataThanks raja, those links are pretty useful. i decided to use sum(1) over (rows unbounded precedings) and it works well.   Shrini, looks like identity column cannot be used as a primary key. ...
420 Aug 2014 @ 07:29 PDTGeneralReplyIntroduce sequence number on Full row duplicates dataHi All, I found sum(1) over( rows unbounded preceding ) to be an interersting substitute, but i would like to hear some experts advice on using this condition.   Please advice.   Reg...
320 Aug 2014 @ 07:07 PDTGeneralTopicIntroduce sequence number on Full row duplicates dataHi All, I have a very wierd requirement that i need to load a file containing full row duplicate as shown below in to a table without losing any value and it should also contain a primary key defi...
207 Aug 2014 @ 06:06 PDTGeneralReplyQuery to update the sequence number of duplicate rowsThank you very much Dieter, it works exactly as i expected.
107 Aug 2014 @ 04:13 PDTGeneralTopicQuery to update the sequence number of duplicate rowsHi All, I am new to teradata and this is my first post. I would like to know the possibility of generating a query with which can order the duplicate row in sequence.   for ex: field 1&nb...