Обсуждение: [SQL] Substracting Date field from integer value in another field

Поиск
Список
Период
Сортировка

[SQL] Substracting Date field from integer value in another field

От
Abdul Hameed
Дата:

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.

Re: [SQL] Substracting Date field from integer value in another field

От
Rene Romero Benavides
Дата:
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/

Re: [SQL] Substracting Date field from integer value in another field

От
"Abdul Hameed Kareem -X (abdukare - HCL TECHNOLOGIES LIMITED at Cisco)"
Дата:

Hi Rene,

 

That works. Thanks for your prompt reply.

 

Thanks

Abdul Hameed

 

https://www.cisco.com/c/dam/m/en_us/signaturetool/images/logo/Cisco_Logo_no_TM_Indigo_Blue-RGB_43px.png

Abdul Hameed Kareem

Technical Lead

abdukare@cisco.com

Tel:

 

 

 

 

Cisco Systems, Inc.

 

 

 

India

cisco.com

http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif

Think before you print.

This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.

Please click here for Company Registration Information.

 

 

From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Rene Romero Benavides
Sent: 30 August 2017 18:23
To: Abdul Hameed <atheequeahmed@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] 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@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/