For example, I have two timestamp values ('2024-04-01 10:00:00', '2024-04-01 11:30:30'). I would like to find the difference between these two timestamps, and I need the result in hours:minutes:seconds (hh:mm:ss) format.

Expected Output: 01:30:30


Note: I need an SQL query command. I should not use ClassMethod, Function, or Stored Procedure.


Could anyone please provide me with an SQL query for my question?

0 4
0 203

Hello all,

I am trying to start java gateway and constantly getting an error in terminal:
"%RemoteService+3^%Net.Remote.Gateway.1 *%Exception.StatusException ERROR #5023: Remote Gateway Error: TCP error on port '55555', ensure there is an Object Gateway running on this port". I've checked jvm and it is running properly, telnet also is able to connect to the port.

Has anyone encountered this issue before?

1 2
0 262