getdate

常见例句

The expression uses the DATEPART and GETDATE functions and the conditional operator.
該表達式使用DATEPART和GETDATE函數以及條件運算符。
The information the GETDATE function returns is equivalent to the information returned by the NOW function and the CURRENT TIMESTAMP special value.
GETDATE函數返廻的信息與NOW函數返廻的信息及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.
內置RAND和GETDATE系列非確定性函數在運行時是確定的,除此之外,其數量、順序和調用時間均取決於所選擇的計劃。
DATEDIFF(day,0,A)=datediff(day,0,getdate
的大把，昨天的，前天的，都不等於0。
select getdate() into :ldt_now from table;
最好是取服務器時間.
create VIEW viewTest (now,rand) AS SELECT getdate(),rand();
在函數中可以調用這個眡圖.