<div>
Since you want minutes as a decimal also, I think you have to use a method similar to this:<br />
<br />
DECLARE @hrsDiff DECIMAL(4,2)<br />
<br />
SET @hrsDiff = DATEDIFF(hour, ORDEROn, ORDEROff) + <br />
CAST(CAST(DATEDIFF(minute,<wbr /> ORDEROn, ORDEROff) % 60 AS DECIMAL(4,2)) / 60.0 AS DECIMAL(4,2))<br />
<br />
That's ugly, I know, but AFAIK there's not an easier way to do it.<br />

</div>


Since you want minutes as a decimal also, I think you have to use a method similar to this:

DECLARE @hrsDiff DECIMAL(4,2)

SET @hrsDiff = DATEDIFF(hour, ORDEROn, ORDEROff) +
CAST(CAST(DATEDIFF(minute, ORDEROn, ORDEROff) % 60 AS DECIMAL(4,2)) / 60.0 AS DECIMAL(4,2))

That's ugly, I know, but AFAIK there's not an easier way to do it.


<div>
If you want hours and minutes as decimal, you could just do <br />
<br />
DATEDIFF(minute, ORDEROn, ORDEROff) /60<br />
<br />
Will
</div>


If you want hours and minutes as decimal, you could just do

DATEDIFF(minute, ORDEROn, ORDEROff) /60

Will

<div>
DateDiff(hour,[OrderON],[O<wbr />rderOFF]) worked perfectly. &nbsp;Thanks...<br />
<br />
<br />

</div>


DateDiff(hour,[OrderON],[OrderOFF]) worked perfectly.  Thanks...




<div>
<div class="content wysiwyg-content">
I am converting an app from MS Access 2000 to use a VB front end with SQL Server as the database.<br />
<br />
I have two datetime fields ORDEROn and ORDEROff. &nbsp;When I subtract ORDEROn from ORDEROff in a SQL statement in MS Access I get the number of hours in decimal format. &nbsp;But SQL Server returns 1901-01-01 00:00:0.000 no mater what the values are in the two DateTime fields. &nbsp;<br />
<br />
How can I make SQL Server return the number of hours and minutes of difference between these two fields?<br />
<br />

</div>
</div>


I am converting an app from MS Access 2000 to use a VB front end with SQL Server as the database.

I have two datetime fields ORDEROn and ORDEROff.  When I subtract ORDEROn from ORDEROff in a SQL statement in MS Access I get the number of hours in decimal format.  But SQL Server returns 1901-01-01 00:00:0.000 no mater what the values are in the two DateTime fields.  

How can I make SQL Server return the number of hours and minutes of difference between these two fields?



Doing DateTime Math with SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.