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 -> Re: sql date function

Re: sql date function

From: Dirk Tschentscher <dirk.tschentscherREMOVE_at_THISvolkswagen.de>
Date: Fri, 22 Nov 2002 12:33:51 +0100
Message-ID: <arl4mr$1r34@doiweb4.volkswagen.de> 





Hi Maros,



select to_char(datefield,'WW') from...




Look for date functions in the manual.



Rgds


    Dirk



"Maros Kollar" <spam_at_k-1.com> schrieb im Newsbeitrag
news:3dde0d50$0$13686$3b214f66_at_news.univie.ac.at...


> hi,

> i need a sql command to convert a date (unix timestamp, or other

fomrat like


> yyyy-mm-dd) into a weeknum

> i'm using oracle 8i

>

> regards

> maros

>

>

Received on Fri Nov 22 2002 - 05:33:51 CST












Original text of this message













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