SELECT *
FROM mytable
WHERE to_char(datefield, 'Mon') = 'May'
AND to_char(datefield, 'dd') = '05'
AND to_char(datefield, 'yyyy') = '2004'
----- Original Message -----
From: "daniel kessler" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 25, 2004 3:14 PM
Subject: Re: date search
> >So, instead of createDate, I went to
> >createDateTime. Since then, I've not been able to search on these
> >items with my query that uses CreateDate. It doesn't seem right to
> >have to include the time for searching, especially since I just want
> >items on a particular date or series of date.
> >I'm not sure how to go about forming a query on this, really.
>
> Should I maybe just search on the elements of a date: month, day, year and
leave out time? Not sure if that's even possible, beyond whether it's a
good idea.
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
