Convert minutes into hours in SQL

Question

I want to convert 300 minutes into 5 hours. Input is 300 Output should be 05:00

which Sybase RDBMS product (ASE? IQ? SQLAnywhere? Advantage?) — markp-fuso, Jan 17 '23 at 15:27

score 0 · Accepted Answer · answered Jan 17 '23 at 06:37

0

Try this:

select convert(varchar(5), dateadd(MINUTE, 300, '1970-01-01'), 108)

answered Jan 17 '23 at 06:37

gotqn

42,737
46
157
243

score 0 · Answer 2 · answered Jan 17 '23 at 06:47

0

Try this

` DECLARE @FirstDate datetime, @LastDate datetime

SELECT
@FirstDate = '2000-01-01 09:00:00',
@LastDate = '2000-01-01 11:30:00'

SELECT CONVERT(varchar(12), 
DATEADD(minute, DATEDIFF(minute, @FirstDate, @LastDate), 0), 114)

`

answered Jan 17 '23 at 06:47

Akshay Phadke

81
5

Isn't really the question, because I only have minutes and no date. – Omar Ozan Jan 17 '23 at 07:41

Convert minutes into hours in SQL

2 Answers2