date comparison

From: Raj <raj.kothary_at_thus.net>
Date: Wed, 8 Mar 2006 14:22:14 -0000
Message-ID: <dumpe7$gde$1$8300dec7@news.demon.co.uk>

Hi all,

I need to compare two dates...one stored in a table and the other user generated.

The table column time is of the format 08/03/2006 07:31.

The user generated time is 2006/03/08.

I am currently comparing them like this:

...

WHERE to_date(to_char(time, 'yyyy/mm/dd'), 'yyyy/mm/dd') = to_date('2006/03/08', 'yyyy/mm/dd')
...

This doesn't look very efficient to me though. Can anyone please advise?

Thanks in advance!

Regards

-- 
Raj Kothary :: one|concept

Received on Wed Mar 08 2006 - 08:22:14 CST