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

Home -> Community -> Usenet -> c.d.o.misc -> date functions

date functions

From: <Jiri.Felcman_at_noofs.abb.no>
Date: Thu, 18 Nov 1999 11:56:40 GMT
Message-ID: <810phn$iln$1@nnrp1.deja.com> 





Does anybody know what is the easiest way to be able to use special
date/time functions (getweeknumber, daysbetween, isyearleap ...) in
ORACLE SQL? For example - I have statistics data calculated every 30
minutes and I want to create a view where all data will be grouped by
week number.



Is there any PL/SQL package or should a C(C++) component be used?



Thanks and with regards



Jiri




Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Thu Nov 18 1999 - 05:56:40 CST












Original text of this message













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