Archives of the TeradataForum

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

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

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