Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Number of days since a certain date.
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