On 21 May 2003 at 16:27, Madhavi Daroor wrote:
> I need to compare this difference with a numeric value in my WHERE clause
> like this
>
> WHERE
> TIMESTAMP('05-21-2003 00:00:00','mm-dd-yyyy') - TO_TIMESTAMP('04-30-2003
> 00:00:00','mm-dd-yyyy') > 30
Try
WHERE
(TIMESTAMP('05-21-2003 00:00:00','mm-dd-yyyy') - TO_TIMESTAMP('04-30-2003
00:00:00','mm-dd-yyyy'))::integer > 30
or something like that...
> Please reply SOON !!!
And why is that?
I am sure you would agree that it is not polite when you are asking for help.
Bye
Shridhar
--
lp1 on fire(One of the more obfuscated kernel messages)