GETDATE():
GETDATE()
function returns the current database system timestamp. This value is derived from the operating system of the computer on which the instance of SQL Server is running.
If you are connected to the SQL server remotely then the timestamp displayed will be the timestamp of the SQL server machine and not your local machine.Usage: SELECT GETDATE() as [ServerTime]
GETUTCDATE():
GETUTCDATE() function returns the current UTC time. This value is derived from the operating system of the computer on which the instance of SQL Server is running.
This can be used to store the timestamp that is independent of Time Zones.
Usage:
SELECT GETUTCDATE() as [UTCTime]
1 comment:
Aivivu đại lý vé máy bay, tham khảo
Ve may bay di My
các chuyến bay từ mỹ về việt nam hiện này
mua vé máy bay từ nhật bản về việt nam
vé máy bay từ đức về sài gòn
vé máy bay từ canada về việt nam
vé máy bay từ hàn quốc về việt nam
khách sạn cách ly
vé máy bay chuyên gia nước ngoài
Post a Comment