SELECT TOP (200) Emp_ID, ProxyNo, EmpName, JoiningDate, Dept_Name, Designation, Emp_Type, Atten_date, OriginIntime, EIntime, EOutTime, Status, Shift, Overtime, OutTimeCal, TotOT, RealOT, EOT, MorOT,
TimeDedu, SDate, EDate, PDay, AbDay, CLDay, ELDay, SLDay, WDay, FDay, WorkHrs, Pstatus, Section, Unit_Name, SubSection, ComID
FROM Temp_JobCard
WHERE (RealOT = 1.50)
Here I want to show 1.5 = 01:30 that means, if the result is 1.5 it will show me 01:30 .Same as 1.25= 01:15. Basically i need to show time,hour to convert this numeric number.
What I have tried:
SELECT CONVERT(datetime,REPLACE('1.5','.',':'))
My output is
1900-01-01 01:05:00.000
But its not correct.
But I need output is
01:30<pre>