Select Date field problem
From: Greg Kearney <sticinc_at_mediaone.net>
Date: Mon, 05 Feb 2001 20:06:41 GMT
Message-ID: <lJDf6.4704$En4.124558_at_typhoon.jacksonville.mediaone.net>
Date: Mon, 05 Feb 2001 20:06:41 GMT
Message-ID: <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 - 21:06:41 CET