What do I use in Sql to replace a subtraction symbol

[Anthony97]

I am using some code from an access db that works how do I convert it in SQL?
Below is one line of the code. Thanks as always for your help.

[Loading Time In]-[order time in] AS [percent of load]

[nbiswas]

Use the DATEDIFF function whose general syntax is

DATEDIFF ( datepart , startdate , enddate )

So for your case the query will be

Select Datediff(day,[Loading Time In],[order time in]) AS [percent of load]


Note that I am finding the difference in days. You can find it in hours, minutes, seconds, years, etc.

For a more detailed knowledge on the DATEDIFF function, please visit

http://msdn.microsoft.com/en-us/library/ms189794.aspx


Hope this will help you.