Adding Time in HH:MM Format - Useful SQL Query

Shahriar Iqbal Chowdhury/Galib

Rate me:

5.00/5 (2 votes)

7 Jun 2011CPOL

11.3K

Hi,Here is an alternative for your solutionSELECT CAST(DATEADD(MILLISECOND,SUM(DATEDIFF(MILLISECOND,0,CAST(TMP.TotalTime as DATETIME))),0) as TIME)FROM( SELECT CAST(timeduration AS TIME) TotalTime FROM mytable) TMP

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

1. Adding Time in HH:MM Format - Useful SQL Query

11 Feb 2012Jobless Creature

2 alternatives

HH:MM Time format addition

SQL

SQL-Server

SQL-Server-2005

2. Adding Time in HH:MM Format - Useful SQL Query

10 Feb 2012abdul sami

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

SQL

SQL-Server

SQL-Server-2005

License

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

Written By

Shahriar Iqbal Chowdhury/Galib

Chief Technology Officer

Bangladesh

I am a Software Engineer and Microsoft .NET technology enthusiast. Professionally I worked on several business domains and on diverse platforms. I love to learn and share new .net technology and my experience I gather in my engineering career. You can find me from here

Personal Site
Personal Blog
FB MS enthusiasts group
About Me

Adding Time in HH:MM Format - Useful SQL Query

Alternatives

License

Comments and Discussions