Problem with date conversion

From: <bthomas_at_eises.equipement.gouv.fr>
Date: 1997/07/29
Message-ID: <870169462.15286@dejanews.com>#1/1

Hello.

I want to calc the month when I know the year (YYYY) and the week (WW). If I try the query :

      SELECT TO_CHAR(TO_DATE('199701', 'YYYYWW'), 'MM')
      FROM dual;

I got the error 'ORA-1820, format code cannot appear in date input format'

Can you help me, please ?

And it's better if you can send a copy by mail...

Thank you.

Bruno Thomas <mailto:bthomas_at_eises.equipement.gouv.fr>

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Tue Jul 29 1997 - 00:00:00 CDT