Thread: Is There any function to get Difference of Dates

Is There any function to get Difference of Dates

From

"shreedhar"

Date:

16 January 2003, 07:36:45

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)

Re: Is There any function to get Difference of Dates

From

"shreedhar"

Date:

16 January 2003, 08:10:13

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
>

Re: Is There any function to get Difference of Dates

From

"Rajesh Kumar Mallah."

Date:

16 January 2003, 09:37:34


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.

Re: Is There any function to get Difference of Dates

From

Steve Crawford

Date:

16 January 2003, 14:54:41

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