Archives of the TeradataForum

Message Posted: Thu, 02 Sep 2004 @ 10:01:04 GMT

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

Dieter,

That's great; but if you say ISO A you should say ISO B. ISO specifications include not only weeks but also years. Compare, for example, how Oracle presents them:

     SQL> select to_char(to_date('20050102', 'YYYYMMDD'), 'YYYY-WW')
       2  from dual ;

     TO_CHAR
     -------
     2005-01

     SQL>
     SQL> select to_char(to_date('20050102', 'YYYYMMDD'), 'IYYY-IW')
       2  from dual ;

     TO_CHAR
     -------
     2004-53

If we mix ISO weeks with calendar years, then, in this example, Jan 2, 2005 will be booked on the 53-rd week of 2005. It does not even exist!

I second that it would be great to have the full ISO specs in Teradata so that we don't have to re-invent this wheel again and again.

Regards,

Victor

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