Re: Substracting Date field from integer value in another field

Try this:
SELECT ACS_TIMESTAMP - acct_session_time * '1 second'::interval FROM
RADIUS_ACC_48

2017-08-30 6:20 GMT-05:00 Abdul Hameed <atheequeahmed(at)gmail(dot)com>:

> Getting below error.
>
>
> ERROR: operator does not exist: timestamp with time zone - bigint
>
> LINE 65: ACS_TIMESTAMP-acct_session_time/(24*60*60) ELSE ACS_TIMESTAM..
>
>
>
> I have a table with one column as timestamp (Logon Time), another column
> as integer(seconds).
>
> I would like to deduct the logon time(timestamp) – integer field(seconds)
> to get the final value in TIMESTAMP format.
>
>
> SELECT ACS_TIMESTAMP - acct_session_time FROM RADIUS_ACC_48
>
>
> ERROR: operator does not exist: timestamp with time zone - bigint
>
> LINE 65: ACS_TIMESTAMP-acct_session_time/(24*60*60) ELSE ACS_TIMESTAM..
>
>
> Please let me know the syntax for that.
>

--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/