Archives of the TeradataForum

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

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

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>>