Re: Is There any function to get Difference of Dates - Mailing list pgsql-admin

From shreedhar
Subject Re: Is There any function to get Difference of Dates
Date
Msg-id 00b601c2bd47$7005c830$1201a8c0@a4005
Whole thread Raw
In response to Is There any function to get Difference of Dates  ("shreedhar" <shreedhar@lucidindia.net>)
List pgsql-admin
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
>


pgsql-admin by date:

Previous
From: "shreedhar"
Date:
Subject: Is There any function to get Difference of Dates
Next
From: Andre Schubert
Date:
Subject: Re: Problems with PGOPTIONS