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.




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

В списке pgsql-sql по дате отправления:

Предыдущее
От: Abdul Hameed
Дата:
Сообщение: [SQL] Substracting Date field from integer value in another field
Следующее
От: "Abdul Hameed Kareem -X (abdukare - HCL TECHNOLOGIES LIMITED at Cisco)"
Дата:
Сообщение: Re: [SQL] Substracting Date field from integer value in another field