Combining hours and min (hh:mm)

[skurkal]

Hi All,

I have a table with 2 integer colums

HourPart TimePart
13 15
14 30

I need to combine these into a time colum as follows

Time
13:15
14:30

Thanks for your help in advance,
sk

 

[RiverGuy]

SELECT RIGHT('0' + CONVERT(CHAR(2), HourPart), 2) + ':' + RIGHT('0' + CONVERT(CHAR(2), TimePart), 2)

 

[SkipVought]

Hi,

Select TimeSerial([HourPart],[TimePart],0)...

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[RiverGuy]

Is TimeSerial a T-SQL function?

 

[SkipVought]

I thought I was in a different forum

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[CGLuttrell]

The above code will leave spaces for single digit input.
Try this:

SELECT RIGHT('0' + CONVERT(VARCHAR, 2), HourPart) + ':' + RIGHT('0' + CONVERT(VARCHAR, TimePart), 2) as Time