<div>
&gt;&gt; I want to subtract 1 hour from ThisMoveTime&lt;&lt;<br />
In an ORDER BY clause? If so, that does not make any sense. Also, lose the alias &quot;AS DepartTime&quot;
</div>


>> I want to subtract 1 hour from ThisMoveTime<<
In an ORDER BY clause? If so, that does not make any sense. Also, lose the alias "AS DepartTime"

<div>
No need to sort by a date minus one hour, the sorting should be the same then date field...
</div>


No need to sort by a date minus one hour, the sorting should be the same then date field...

<div>
please show the full query...<br />
<br />
and explain what you're attempting to do..<br />
<br />
&nbsp;
</div>


please show the full query...

and explain what you're attempting to do..

 

<div>
see when you give dateadd with this mv4.ThisMoveTime, then it will get the value from the expression i.e. minus one hour then only do the order by .. So i think it will work<br />
<br />
Cheers<br />
Senthilraj
</div>


see when you give dateadd with this mv4.ThisMoveTime, then it will get the value from the expression i.e. minus one hour then only do the order by .. So i think it will work

Cheers
Senthilraj

<div>
<div class="content wysiwyg-content">
I have this line in a query. I want to subtract 1 hour from ThisMoveTime<br />
<br />
&nbsp;ORDER BY mv4.ThisMoveTime DESC) AS DepartTime
</div>
</div>


I have this line in a query. I want to subtract 1 hour from ThisMoveTime

 ORDER BY mv4.ThisMoveTime DESC) AS DepartTime

Subtract 1 Hour

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.