GetDate and GetUTCDate

今天才发现原来sql server有两种获取当下时间的方法:

a) GETDATE() : Returns local regional time of your SQL SERVER machine (if you are connected to the server remotely)

b) GETUTCDATE(): Returns date and UTC times

Coordinated Universal Time (UTC) is a time standard based on international atomic time with leap seconds added at irregular intervals to compensate for the Earth's slowing rotation.


No comments: