Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 24 Sep 2002 @ 15:33:47 GMT


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


Subj:   Re: Sys_calendar Problem
 
From:   Dieter N�th

Hassinger, Bill wrote:

  I guess I didn't discribe the issue, look closely at the number of months applied to each quarter of the year in the quarter_of_calendar column. 1st qrt = 3 months, 2nd qtr = 4 months, 3rd qtr = 4 months, 4th qtr = 1 month.  



This has been fixed since more than three years, you'll probably find the fixed version of calendartmp in dippatch.bteq


Dieter


REPLACE VIEW CALENDARTMP(
calendar_date,
day_of_week,
day_of_month,
day_of_year,
day_of_calendar,
weekday_of_month,
week_of_month,
week_of_year,
week_of_calendar,
month_of_quarter,
month_of_year,
month_of_calendar,
quarter_of_year,
quarter_of_calendar,
year_of_calendar)
AS
SEL
calendar_date,
(day_of_calendar + 0) mod 7 + 1,
day_of_month,
day_of_year,
day_of_calendar,
(day_of_month - 1) / 7 + 1,
(day_of_month - (day_of_calendar + 0) mod 7 + 6) / 7,
(day_of_year - (day_of_calendar + 0) mod 7 + 6) / 7,
(day_of_calendar - (day_of_calendar + 0) mod 7 + 6) / 7,
(month_of_year - 1) mod 3 + 1,
month_of_year,
month_of_year + 12 * year_of_calendar,
(month_of_year + 2) / 3,
(month_of_year + 2) / 3 + 4 * year_of_calendar,
year_of_calendar + 1900
FROM CALBASICS;




     
  <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