How To Compare Date with Just the Day of Month


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

.

Relevant Pages

  • [HPADM] SUMMARY 2 oracle install and /tmp
    ... Thx for those who responded (I hadnt even seen the original post before I ... Thx to the responders ... Regardless of content, this e-mail shall not operate to ... bind CSC to any order or other contract unless pursuant to explicit written ...
    (HP-UX-Admin)
  • 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)
  • delete rows from datagrid
    ... My problem is that whatever rows I delete, dgDeleted is always empty ... What should I do to store the deleted rows in a dataset so i can ... Thx ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • 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: DVD burner recognizing problem
    ... the system was reboot. ... > next startup the same happened again and again. ... Thx ... Prev by Date: ...
    (microsoft.public.windowsxp.hardware)