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 78

Good afternoon!

Is this a good place to find a fellow developer with specialization in IRIS? I have an opportunity and looking for someone with significant experience (10 years).

It's a two and a half year contract, fully remote. Please let me know if you are interested in speaking about the opportunity.

More info here: https://teckpert.applytojob.com/apply/TudQizeFx2/Senior-Database-Manager...

Best,

Gabriel

TECKpert

0 0
0 64