Re: Date comparison
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: manoj.gurnani@xxxxxxxxxxxxx
- Date: Mon, 12 Sep 2005 11:46:01 +0100
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@xxxxxxxxxxxxx <manoj.gurnani@xxxxxxxxxxxxx> 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.
Other related posts:
