getdate

常見例句

• The expression uses the DATEPART and GETDATE functions and the conditional operator.
  該表達(dá)式使用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;
  最好是取服務(wù)器時間.
• create VIEW viewTest (now,rand) AS SELECT getdate(),rand();
  在函數(shù)中可以調(diào)用這個視圖.
返回 getdate