Hi All,
I got solution from the following link.
http://techdocs.postgresql.org/techdocs/faqdatesintervals.php
Thanks,
Sreedhar
----- Original Message -----
From: "shreedhar" <shreedhar@lucidindia.net>
To: "Postgres" <pgsql-admin@postgresql.org>
Sent: Thursday, January 16, 2003 3:06 PM
Subject: [ADMIN] 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)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>