Re: Select Date field problem

select * from events where
to_char(start_date,'MM')= '02';

"Greg Kearney" <sticinc_at_mediaone.net> wrote in message news:lJDf6.4704$En4.124558_at_typhoon.jacksonville.mediaone.net...
> I having a small problem with an O8i database date field, I'm sure its
> something I did.
>
> Example:
> select * from events where start_date like to_date('02','mm')
>
> This command will pull up only one record, I have 3 Feb records. If I
 change
> the 02 to something else I get nothing, even though I have records. If I
> change the "like" to an "=" I get no records.
>
> Does anybody have any suggests?
>
> Thanks.
>
>
Received on Mon Feb 05 2001 - 23:59:30 CET