On Oct 15, 7:33 pm, "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.
Can't your front end just pass a proper DATE variable?
Received on Wed Oct 17 2007 - 01:57:52 CDT
