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

From Rajesh Kumar Mallah.
Subject Re: Is There any function to get Difference of Dates
Date
Msg-id 200301161712.30744.mallah@trade-india.com
Whole thread Raw
In response to Is There any function to get Difference of Dates  ("shreedhar" <shreedhar@lucidindia.net>)
List pgsql-admin

what abt:

 select * from temptbldate WHERE current_date - date(tdate) < CAST ('2 days' AS INTERVAL) ;

?

regds
mallah.


 (EXTRACT(EPOCH FROM TIMESTAMP 'now()')  -
 EXTRACT(EPOCH FROM TIMESTAMP tdate)  )/ 86400 < 2


On Thursday 16 January 2003 03:06 pm, shreedhar wrote:
> 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

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.



pgsql-admin by date:

Previous
From: "d ravipati"
Date:
Subject: Database server time zone
Next
From: Bruno Wolff III
Date:
Subject: Re: Database server time zone