Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 02 Sep 2004 @ 05:04:57 GMT


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


Subj:   Re: Generating week dates without sys_calendar
 
From:   Dennis Calkins

Hi,

I like the last post. It points out that SYS_CALENDAR is not complete and maybe it could be improved upon.

I guess the question would be would it be better to add extra columns to the current existing view

     SYS_CALENDAR.CALENDAR

or would it be simpler to have a separate view which uses the European or ISO definitions of YEAR START, MONTH START, WEEK START?

Or Maybe a series of UDFs to produce the Calendar functions inline without needing to JOIN to Sys_calndar?

As Always We would love to hear from you.

If you have suggestions for an improvement to The Teradata database or Teradata client products to make your life as a DBA, Programmer or Sysadmin better feel free to submit a Partners enhancement request.

www.teradata.com/teradata-partners/about/enhance.shtml



     
  <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