getdate

基本解釋

The expression uses the DATEPART and GETDATE functions and the conditional operator.
該表達式使用DATEPART和GETDATE函數(shù)以及條件運算符。
The information the GETDATE function returns is equivalent to the information returned by the NOW function and the CURRENT TIMESTAMP special value.
GETDATE函數(shù)返回的信息與NOW函數(shù)返回的信息及CURRENT TIMESTAMP特殊值相同。
Aside from runtime constant nondeterministic built-ins RAND, and the GETDATE family, the number, order, and timing of calls will depend on the plan chosen.
內(nèi)置RAND和GETDATE系列非確定性函數(shù)在運行時是確定的,除此之外,其數(shù)量、順序和調(diào)用時間均取決于所選擇的計劃。
DATEDIFF(day,0,A)=datediff(day,0,getdate
的大把，昨天的，前天的，都不等于0。
select getdate() into :ldt_now from table;
最好是取服務器時間.