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

"Rhugga" <chuck.carson@xxxxxxxxx> wrote in
news:1122557420.795340.5200@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

>
> 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
>
>

You are using the wrong end of the shovel to dig a hole.

Is "$bcv_sdate[$j]" a string or a date datatype?

This appears to be SQL embedded in PERL code.

WHERE TRUNC(BCV_START) = $bcv_sdate[$j]?
.

Relevant Pages

  • Sort a Find Combo Box
    ... sub form shows ALL contacts, regardless of family; not just the ones for the ... Dee ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • RE: [Full-disclosure] Useless tidbit (MS AntiSpyware)
    ... > hole, it's definitely concerning. ... machines you darn well should be concerned, regardless of whether its ... out such that arbitrary executables can actually get onto the machines ... advocated by lame system admins has this (and dozens of ...
    (Full-Disclosure)
  • Re: The difference between them and us..
    ... regardless of their performance in our statistical sampling." ... The stats on putts per hole (nearly half a stroke worse than pros) and ... is a good score on any hole. ...
    (rec.sport.golf)
  • Re: delegate question!
    ... Does it mean, anytime when a delegate is called, regardless of which ... worker thread they are in, it get executed in the primary UI thread? ... is it my stupid assumption? ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: OT When it gets tough for BushCo
    ... Regardless, care to provide some proof to your supposed fact? ... Prev by Date: ...
    (rec.boats)