Archives of the TeradataForum

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

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

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