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
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
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()&
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
