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

Home -> Community -> Usenet -> c.d.o.tools -> Re: All Dates

Re: All Dates

From: Reinier <Reinier_Dickhout_at_hetnet.nl>
Date: Tue, 3 Oct 2000 10:03:01 +0200
Message-ID: <eBV6jCRLAHA.228@net003s>

As the SQL*Language reference will probably tell you...

select date_field
from table_name
where date_field between start_date and end_date;

Really basic SQL.
But be carefull with the 'between' in combination with dates, since the date also has a time in it it can result in unexpected results. Think about using the trunc-function

Reinier.

Ganesh R <gans_r_at_my-deja.com> wrote in message news:8qrrqp$2mt$1_at_nnrp1.deja.com...
> Hi,
>
> I want to fetch all the dates btw. to given dates. This can be achived
> thru PL?SQL but i want to get it thru a Select Statement.
>
> Any Help
>
> Regards,
> Ganesh R
>
> --
> Regards,
> Ganesh R
>
> --
> Regards,
> Ganesh R
>
> --
> Regards,
> Ganesh R
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 03 2000 - 03:03:01 CDT

Original text of this message

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