#DateForumTypeThreadPost
9007 Jan 2016 @ 12:06 PSTDatabaseReplyISO calendar : previous week number issue thanks alot it's useful and working
8906 Jan 2016 @ 08:35 PSTDatabaseReplyISO calendar : previous week number issue can any one suggest me to find the preivous weeknumber  from the current week in the format of YYYYWW. i request for the forum help
8806 Jan 2016 @ 01:46 PSTDatabaseReplyISO calendar : previous week number issue Hi Dnoeth thanks alot for your reply . is it possible to know the previous week number by using the current week in the format of YYYYWW ex: 201601 preivous week 201553 according to ISO would ...
8705 Jan 2016 @ 09:45 PSTDatabaseTopicISO calendar : previous week number issue Dears i'm using ISO date calendar in my data analysis ; Observed that in ISO calendar for the end of the week of December -2015 i.e  for the dates 28/12/2015 to 03/12/2016 wee...
8622 Oct 2014 @ 03:48 PDTDatabaseReplyStart dates overlap Hi Dieter   Thanks for your reply the rule is based on the Per_id . unique_id     struc_name    per_id  username  start_dt  end_dt 001bb...
8521 Oct 2014 @ 01:07 PDTDatabaseReplyStart dates overlap any one please suggest me how to achieve this output
8421 Oct 2014 @ 04:27 PDTDatabaseTopicStart dates overlap Dears I'm struggling to find a solution for the start dates overlap to continue with my analysis   unique_id     struc_name    per_id  username&n...
8329 Mar 2013 @ 10:35 PDTToolsTopicPASING PARAMETERS TO BTEQ Hi   i have the start and end dates in a table and i need to use this dates to call a stored procedure in the Bteq   sel start_dt , end_dt  from table1   CALL  PROC_C...
8207 Feb 2013 @ 12:45 PSTGeneralTopichow to find the start dates from the Transaction history Hi   i'm trying to write a sql to know the start date for a customer , the data looks like   Case :1 customer       start date    &nb...
8107 Feb 2013 @ 12:21 PSTDatabaseReplyhow to find the start dates from history your second query is not working for case:2 scenario. any one would please help me
8007 Feb 2013 @ 12:08 PSTDatabaseReplyhow to find the start dates from history thanks for the reply, yes its a typo error . in case:2 the start date is 13/01/2011.
7906 Feb 2013 @ 11:00 PSTDatabaseReplyhow to find the start dates from history any one please help me to write the sql to get  this result
7806 Feb 2013 @ 08:36 PSTDatabaseTopichow to find the start dates from history Hi   i'm trying to write a sql to know the start date for a customer , the data looks like   Case :1 customer       start date    &nb...
7717 Oct 2012 @ 04:52 PDTDatabaseReplyvarchar to timestamp conversion its working thank you .   i thought teradata 12  will  able to convert the V2R timestamp format . 
7617 Oct 2012 @ 02:56 PDTDatabaseReplyvarchar to timestamp conversion Any quick help please  
7517 Oct 2012 @ 02:29 PDTDatabaseReplyvarchar to timestamp conversion Any quick help please
7417 Oct 2012 @ 02:05 PDTDatabaseReplyvarchar to timestamp conversion thanks its working .   if my timestamp will be in the format  '20-SEP-12 02.27.45.145000 PM' then the given query is failing with error message invalid time .  
7317 Oct 2012 @ 01:51 PDTDatabaseReplyvarchar to timestamp conversion i want to extract time from the data and time attribute in the format of  'HH:MI:SS' , but Teradata showing me invalid timestamp
7217 Oct 2012 @ 01:40 PDTDatabaseTopicvarchar to timestamp conversion Hi   i have a column with date and time in varchar , im trying to convert it to timestamp .   sel cast(''12/25/1994 11:46:29PM'  as timestamp(0) format 'DD-MM-YYY...
7116 Oct 2012 @ 09:42 PDTDatabaseReplySQL Help : Left join ANY  suggestions about the same
7016 Oct 2012 @ 09:18 PDTDatabaseTopicSQL Help : Left join Hi   im writing a sql  query with Left join  :   sel a.* ,b.ordr_date from   tbl_cust_info  a left join  tbl_ordr_date  b on  a.customer=b....
6909 Jul 2012 @ 12:31 PDTDatabaseReplyCummulative Counting records with a condition @ thanks for your solution  Dnoeth , i will try this query   @ Ulrich :   yes ,The Input table may contains the Last_closed_date same for different creation_dates ...
6809 Jul 2012 @ 08:30 PDTDatabaseReplyCummulative Counting records with a condition no the last_closed_date will not be the same ,  we will have only one record in that case     100           &nbs...
6709 Jul 2012 @ 07:52 PDTDatabaseTopicCummulative Counting records with a condition Hi ,   I have a set of records as follows : customer unique_cust_code creation_date_by_mail     last_closed_date 100      ...
6608 Feb 2012 @ 07:26 PSTDatabaseReplyEnd of line in a string i tried with this its not working . Giving an empty space  whether we need to take end of line ?

Pages