Re: [SQL] Substracting Date field from integer value in another field
| От | Rene Romero Benavides |
|---|---|
| Тема | Re: [SQL] Substracting Date field from integer value in another field |
| Дата | |
| Msg-id | CANaGW08VGxsgT5EWdyQU7278BDuEyX8VTG=Z7QFHGWBqFkAe=Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | [SQL] Substracting Date field from integer value in another field (Abdul Hameed <atheequeahmed@gmail.com>) |
| Ответы |
Re: [SQL] Substracting Date field from integer value in another field
|
| Список | pgsql-sql |
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@gmail.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.
В списке pgsql-sql по дате отправления: