How to convert the integer to Time using SQL query ???

[Former Member]

Hi Experts,         

  How to convert the integer to Time using SQL query ???

For Ex,

Integer Format               Time Format

     1115              =>         11:15 AM

Regards,

K.Ramasamy

[former_member143715 · Accepted solution]

try this

SELECT CONVERT( TIME, STUFF( RIGHT( '0000' + CONVERT( VARCHAR(5), '1115'), 4), 3, 0, ':'))

[Former Member · Accepted solution]

Mokthar ,     Also I need the difference between two dates &  time using the above query .. Regards, K.Ramasamy

[former_member143715 · Accepted solution]

you must use datediff :

SELECT DATEDIFF(hh, '01/08/2015 12:00', '04/08/2015 00:00')

[Former Member · Accepted solution]

mokhtar     I am having date in separate field & Time in separate field..Then Hw can split up the Difference ?? Regards, K.Ramasamy

[former_member143715 · Accepted solution]

SELECT DATEDIFF(hh, convert(datetime,'01/08/2015 '+'12:00'),convert(datetime,'04/08/2015 '+'00:00') )