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 -> Re: Number of days since a certain date.

Re: Number of days since a certain date.

From: Igor Sereda <sereda_at_rus.net>
Date: Thu, 03 Sep 1998 13:22:08 +0400
Message-ID: <35EE5FC0.3D9B88B1@rus.net>


Hi,

SELECT (TRUNC(SYSDATE-4,'D') - TRUNC(YOURDATE-4,'D'))/7 FROM DUAL; Regards,

Iain Crawford wrote:
>
> Can anyone help me here??
>
> I need to know how many Thursdays there have been between a certain date
> and the current date. Can anyone give me any ideas on how this can be
> done in SQL*Plus.
>
> Thanks

--
Igor Sereda sereda_at_rus.net
Internet Technology Center, Russia
+7-812-3272860 icq 7596845 Received on Thu Sep 03 1998 - 04:22:08 CDT

Original text of this message

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