yes, compare dates to date and you can;t go wrong. If you just want the date
part use trunc()
On 9/12/05, manoj.gurnani_at_polaris.co.in <manoj.gurnani_at_polaris.co.in> wrote:
>
>
>
>
>
>
> Hi All,
> I've a date column in a oracle db table which stores date and
> time values.
> Is it advisable to use a date variable directly in a comparison with a
> date
> column
> without any formatting or using any other conversion functions like
> to_char.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 12 2005 - 05:47:56 CDT
