Adding Time in HH:MM Format - Useful SQL Query

abdul sami

0/5 (0 vote)

Feb 10, 2012

CPOL

5461

select aday, code, convert(varchar(5), min(atime), (108))MinTime, convert(varchar(5), max(atime),(108)) MaxTime from testgroup by aday,codeorder by aday asc

select aday, code, convert(varchar(5), min(atime), (108))MinTime, convert(varchar(5), max(atime),(108)) MaxTime

 from test

group by aday,code
order by aday asc