On Jan 8, 2008 8:51 AM, <[EMAIL PROTECTED]> wrote:
> DELETE from CONCURRENT_USER WHERE (now() - CONCURRENT_USER.TIME_STAMP) > ?
>
>
>
> Here the calculated value in '?' is not supported by the postgres as it was
> set as a double.
>
> I tried to cast it to a timestamp by using Timestamp timestamp
On Tue, Jan 08, 2008 at 08:21:40PM +0530, [EMAIL PROTECTED] wrote:
> The query is something like :
>
> DELETE from CONCURRENT_USER WHERE (now() - CONCURRENT_USER.TIME_STAMP) >
> ?
>
> Here the calculated value in '?' is not supported by the postgres as it
> was set as a double.
In postgres subtr
On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, January 08, 2008 8:52 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Time stamp issue
Importance: High
Hi Everyone,
I have a table named concurrent_user which has a column time_stamp. The
column stores the timestamp for the latest en
Hi Everyone,
I have a table named concurrent_user which has a column time_stamp. The
column stores the timestamp for the latest entered record.
My query finds the difference of the timestamp from the current time, if
the value is larger than 5 minutes then the latest entered record in the
tab
