#7 DateToStr number of week

[Anonymous]

Hello,

I would like to suggest an extra parameter for the
DateToStr function to calculate the weeknumber
according to 'European' standard
(http://www.volny.cz/iprenosil/interbase/ip_ib_code_time
stamp.htm#_code3_weekofyear) with which method
januari 1 2004 lies in week 1 and not in week 53.

Thanks in advance.

Arno Rog
Amsterdam
mailto:arno.rog@planet.nl

[PAscal]

Logged In: YES
user_id=1443900
Originator: NO

Hello,

try
select to_char(cast('2004.01.01' as timestamp),'YYYY IW D') from dual;

using the extended version of rFunc UDF Library foud at:
http://perso.orange.fr/Udf4ORA/

Regards
PAscal