Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 24 Sep 2002 @ 14:20:15 GMT


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


Subj:   Re: Sys_calendar Problem
 
From:   David Belcher

Bill,

we are on V2R4.0.3 and the problem does not seem to exist as shown by the following results from the same query:

year_of_calendar  month_of_year  quarter_of_year  quarter_of_calendar
----------------  -------------  ---------------  -------------------

            2002              3                1                  409
            2002              4                2                  410
            2002              5                2                  410
            2002              6                2                  410
            2002              7                3                  411
            2002              8                3                  411
            2002              9                3                  411
            2002             10                4                  412
            2002             11                4                  412
            2002             12                4                  412
            2003              1                1                  413
            2003              2                1                  413
            2003              3                1                  413
            2003              4                2                  414
            2003              5                2                  414
            2003              6                2                  414
            2003              7                3                  415
            2003              8                3                  415
            2003              9                3                  415
            2003             10                4                  416
            2003             11                4                  416
            2003             12                4                  416

David



     
  <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