Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> How to convert a year+week to a date ?

How to convert a year+week to a date ?

From: Deepest Blue <no_at_where.com>
Date: Mon, 5 Feb 2001 14:35:24 +0100
Message-ID: <981380148.833458@dedale.pandemonium.fr> 






I can't find the way to translate a year and week field to a date
datatype with the WW or IW format.


In my string field I have 6 characters like 200108 for week 8 of
year 2001, how can I have the starting date for this week ?
I tried to_date(my_string_field,'YYYYWW') with no success...
I have Oracle 7.3.2.3.0.
Received on Mon Feb 05 2001 - 07:35:24 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US