Re: Comparing Dates

From: Christopher Latta <clatta_at_ozemail.com.au>
Date: Fri, 20 Apr 2001 12:21:42 +1000
Message-ID: <F4ND6.4902$EQ3.168922@ozemail.com.au>

select *
from mytable
where trunc(datefield) = to_date(UserDateAsString, 'mm/dd/yy')

Christopher Latta

Matt Connors <connorsm_at_bellatlantic.net> wrote in message news:iFKD6.1356$yg.1055000_at_typhoon1.ba-dsg.net...
> Table A contains a Date column.
>
> The user enters a date in the format "mm/dd/yy" through a User Interface.
>
> I want to select all records in the table that have a date equal to the
date
> entered by the user. How do I do this?
Received on Thu Apr 19 2001 - 21:21:42 CDT