Re: TIMESTAMP SUBTRACTION

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)