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
Difference between timestamps will give you an interval. So the LHS of
">" is interval and hence the RHS should be an interval too. You should
not be converting the right hand side value to Timestamp. What is the
"double" value you are calculating? Is it in minutes, hours or days?
I am not a Java
