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 -> Re: How To Compare Date with Just the Day of Month

Re: How To Compare Date with Just the Day of Month

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 28 Jul 2005 06:37:52 -0700
Message-ID: <qf6dnUcG-uLxQnXfRVn-rg@comcast.com>

"Rhugga" <chuck.carson_at_gmail.com> wrote in message news:1122557420.795340.5200_at_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
>

  use trunc(bcv_start) trunc on a date removes the fraction of a day and makes it midnight of that day which to_date('$bcv_sdate[$j]', 'MM-DD-YYYY') is. If it is slow then use a function based index on that field. Jim Received on Thu Jul 28 2005 - 08:37:52 CDT

Original text of this message

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