<div>
SELECT &nbsp;TO_CHAR(TO_DATE(TRUNC(MOD(<wbr />date2-date<wbr />1,1)*86400<wbr />),'SSSSS')<wbr />, 'HH24:MI:SS') time <br />
from TABLE <br />
<br />
cast ((datediff(hh,begin_time,e<wbr />nd_time)) + ':' + (datediff(mm,begin_time,en<wbr />d_time)) as varchar(10))<br />

</div>


SELECT  TO_CHAR(TO_DATE(TRUNC(MOD(date2-date1,1)*86400),'SSSSS'), 'HH24:MI:SS') time
from TABLE

cast ((datediff(hh,begin_time,end_time)) + ':' + (datediff(mm,begin_time,end_time)) as varchar(10))


<div>
ignore the first, use the cast.
</div>


<div>
these two work...thanks to aneeshattingal (a little format there) and mwvisa1<br />
1) SELECT CONVERT(varchar(5),endtime<wbr /> - starttime,108) from timesheet<br />
<br />
2) SELECT starttime,endtime,CONVERT(<wbr />VARCHAR(5)<wbr />, DATEADD(mi, DATEDIFF(mi, starttime, endtime), 0), 108) FROM timesheet<br />
<br />
ged325 yours gave me this error..<br />
&quot;Conversion failed when converting the varchar value ':' to data type int.&quot;<br />
<br />
<br />
thanks everyone!
</div>


these two work...thanks to aneeshattingal (a little format there) and mwvisa1
1) SELECT CONVERT(varchar(5),endtime - starttime,108) from timesheet

2) SELECT starttime,endtime,CONVERT(VARCHAR(5), DATEADD(mi, DATEDIFF(mi, starttime, endtime), 0), 108) FROM timesheet

ged325 yours gave me this error..
"Conversion failed when converting the varchar value ':' to data type int."


thanks everyone!

<div>
<div class="content wysiwyg-content">
Hello, ive got to date fields in my db with date and time and id like another column showing the difference in hours an minutes. in hte format hh:mm
</div>
</div>


Hello, ive got to date fields in my db with date and time and id like another column showing the difference in hours an minutes. in hte format hh:mm

get dates difference in hours and minutes

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.