Обсуждение: 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)
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 >
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.
Have you tried age(now(), tdate)? Or just: .....where now()-tdate < '2 days' Cheers, Steve On Thursday 16 January 2003 1:36 am, 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