Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 24 Sep 2002 @ 13:44:56 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Sys_calendar Problem
 
From:   Hassinger, Bill

Below are the results of a query against the sys_calendar table. We are currently on V2R3, and I wanted to share this for two reasons; to alert users of the problem, and to find out if it exists on R4. I have reported the anomaly to NCR.

      select year_of_calendar, month_of_year, quarter_of_year, quarter_of_calendar
       from sys_calendar.calendar
       where year_of_calendar between 2001 and 2003
       group by 1,2,3,4
       order by 1,2 ;

   year_of_calendar   month_of_year   quarter_of_year   quarter_of_calendar   CORRECT VALUES
   2001      11       4        407
   2001      12       4        408
   2002      1        1        409
   2002      2        1        409
   2002      3        1        409
   2002      4        2        410
   2002      5        2        410
   2002      6        2        410
   2002      7        3        410    411
   2002      8        3        411    411
   2002      9        3        411    411
   2002      10       4        411    412
   2002      11       4        411    412
   2002      12       4        412
   2003      1        1        413
   2003      2        1        413

   Bill


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023