Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How To Compare Date with Just the Day of Month

How To Compare Date with Just the Day of Month

From: Rhugga <chuck.carson_at_gmail.com>
Date: 28 Jul 2005 06:30:20 -0700
Message-ID: <1122557420.795340.5200@f14g2000cwb.googlegroups.com>

I have the following date inserted into a DATE field: 07-26-2005 21:00:00

I have some code where I want to see if this date is equal to 07-26-2005, regardless of the time of day.

This is not working form me:
WHERE bcv_start = to_date('$bcv_sdate[$j]', 'MM-DD-YYYY')

(The value of $bcv_date is correct, I have check that several times) Thx,
CC Received on Thu Jul 28 2005 - 08:30:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US