getdate
基本解釋
- n.獲取日期
英漢例句
- The expression uses the DATEPART and GETDATE functions and the conditional operator.
該表達(dá)式使用DATEPART和GETDATE函數(shù)以及條件運(yùn)算符。 - 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ù)在運(yùn)行時(shí)是確定的,除此之外,其數(shù)量、順序和調(diào)用時(shí)間均取決於所選擇的計(jì)劃。 - DATEDIFF(day,0,A)=datediff(day,0,getdate
的大把,昨天的,前天的,都不等於0。 - select getdate() into :ldt_now from table;
最好是取服務(wù)器時(shí)間.