Re: querying records with date field

From: Jerome Vitalis <vitalismanN05P4M_at_gmail.com.invalid>
Date: 15 Oct 2007 18:47:02 GMT
Message-ID: <4713b5a6$0$31141$79c14f64@nan-newsreader-07.noos.net>

On Mon, 15 Oct 2007 11:33:38 -0700, mrajanikrishna_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.

Use the to_date SQL function with the proper date format. Received on Mon Oct 15 2007 - 13:47:02 CDT