Select statement to display Minutes in HH:MM Format

Question

0.00/5 (No votes)

See more:

I am having a table (Table Name -Production) in SQL Server.The Production table have a Column TimeSpent (Datatype- varchar(25)) and stores Number of minutes spent . Example 60,78,23 etc. I want to display TimeSpent in HH:MM Format in a select statement. for example it display 01:00 for 60, 01:18 for 78 and so on. Please help me that how i will write this query.

Posted 18-Jul-12 2:57am

Dharmenrda Kumar Singh

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

StianSandberg · Accepted Answer · 2012-07-18T03:38:00

Solution 2

This will give you what you are looking for

SQL

SELECT Convert(varchar(5), DATEADD(minute, Convert(int, YOUR-COLUMN-WITH-MINUTES), ''), 108)

Example:

SQL

SET @TestValue = '130'
SELECT Convert(varchar(5), DATEADD(minute, Convert(int, @TestValue), ''), 108)

-- Result: 02:10

Posted 18-Jul-12 3:38am

StianSandberg

Updated 18-Jul-12 3:39am

v2

Comments

Dharmenrda Kumar Singh 18-Jul-12 9:59am

Thanks For the Quick Response.

Select statement to display Minutes in HH:MM Format

1 solution

Solution 2

Add your solution here

Preview 0

Select statement to display Minutes in HH:MM Format

1 solution

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us