Adding Time in HH:MM Format - Useful SQL Query

abdul sami

Rate me:

0.00/5 (No votes)

10 Feb 2012CPOL

5.4K

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

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

abdul sami

Unknown

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Adding Time in HH:MM Format - Useful SQL Query

Views

License

Comments and Discussions