Is There any function to get Difference of Dates

Hi All,

Is There any function to get Difference of Dates.

Here tdate is of type timestamp

If I tried

select * from temptbldate WHERE (EXTRACT(EPOCH FROM TIMESTAMP 'now()')  -
EXTRACT(EPOCH FROM TIMESTAMP tdate)  )/ 86400 < 2
I got error as 'Parse error at tdate'

select * from temptbldate WHERE (EXTRACT(EPOCH FROM TIMESTAMP 'now()')  -
EXTRACT(EPOCH FROM TIMESTAMP 'tdate')  )/ 86400 < 2
If I use 'tdate',  I got 'bad timestamp external representation 'tdate',
Probably it might be taking 'tdate' as string.

How can I use epoch to get difference of two dates.

Regards,
Sreedhar


"Faith, faith, faith in ourselves, faith, faith in God, this is the secret
of greatness.
If you have faith in all the three hundred and thirty millions of your
mythological gods,
and in all the gods which foreigners have now and again introduced into your
midst,
and still have no faith in yourselves, there is no salvation for you. "
(III. 190)