Re: date functions

From: <murali09_at_my-deja.com>
Date: Thu, 18 Nov 1999 13:45:06 GMT
Message-ID: <810vt1$n4s$1@nnrp1.deja.com>

I am not sure whether this would help, but you can have a look at the site below which uses a single SQL to calculate the no. of business days between two days.

http://www.arrowsent.com/oratip/tip6.htm

Regards,

In article <810phn$iln$1_at_nnrp1.deja.com>, Jiri.Felcman_at_noofs.abb.no wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 18 1999 - 07:45:06 CST