FREE AI-Enhanced Online SQL Server Compiler

Untitled*

You must execute the code again to save those values in the database.

-- INIT database
CREATE TABLE Product (
  ProductID INT IDENTITY(1, 1),
  Name VARCHAR(100),
  Description VARCHAR(255),
  Totalseconds INT
);

INSERT INTO Product(Name, Description,TotalSeconds) VALUES ('Entity Framework Extensions', 'Use <a href="https://entityframework-extensions.net/" target="_blank">Entity Framework Extensions</a> to extend your DbContext with high-performance bulk operations.',4500);
INSERT INTO Product(Name, Description,TotalSeconds) VALUES ('Dapper Plus', 'Use <a href="https://dapper-plus.net/" target="_blank">Dapper Plus</a> to extend your IDbConnection with high-performance bulk operations.',9043);
INSERT INTO Product(Name, Description,TotalSeconds) VALUES ('C# Eval Expression', 'Use <a href="https://eval-expression.net/" target="_blank">C# Eval Expression</a> to compile and execute C# code at runtime.',12858);

SELECT Totalseconds, RIGHT('0' + CAST(Totalseconds/ 3600 AS VARCHAR),2) + ':' +
RIGHT('0' + CAST((Totalseconds/ 60) % 60 AS VARCHAR),2) + ':' +
RIGHT('0' + CAST(Totalseconds % 60 AS VARCHAR),2) as HMS
FROM PRoduct

Totalseconds	HMS
4500	01:15:00
9043	02:30:43
12858	03:34:18

(1 rows affected)

(1 rows affected)

(1 rows affected)

(3 rows affected)