Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: querying records with date field
On Oct 15, 11:33 am, "mrajanikris..._at_gmail.com"
<mrajanikris..._at_gmail.com> wrote:
> hi,
>
> I want to retrieve records from a table by comparing the date field.
>
> select * from mytable where joindate >= <my date variable from front-
> end>
>
> my date variable contains date time value. So I want to check with
> date and time.>From the above query, I need to get records whose joindate >= 2007-
>
> oct-11 19:25:06
>
> How can I write the query to check the dates.
>
> Thanks in advance.
You can try this, replace the date string with a reference to your PLSQL variable:
SELECT * FROM MyTable WHERE JoinDate >= TO_DATE( "2007-OCT-11 19:25:06", "YYYY-MON-DD HH:MI:SS"); George Milliken Received on Mon Oct 15 2007 - 16:44:27 CDT