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

Home -> Community -> Usenet -> c.d.o.server -> Getting the first day of a calendar week (Date Format)

Getting the first day of a calendar week (Date Format)

From: Tom Talberg <tomtberg_at_gmx.net>
Date: Tue, 14 Dec 1999 17:54:16 +0100
Message-ID: <83607r$o3j$1@news.ebn.net> 





Hi everybody,



i have a table-column which stores the calendar week and the year. Its a
number(4) field, 2 digits for the week and 2 for the year. What i want to do
is to transfer this data into another tables column (type date). But Oracle
8.0.5 doesn't accept dates only containing the week and the year. Therefore
i search for a way to determine the first day of the week to store the date
of the first day of the week in the new table.



Thanks in advance for any hints or solutions.



Robert


Received on Tue Dec 14 1999 - 10:54:16 CST












Original text of this message













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