GETDATE() Function in SQL Server

GETDATE() 

This is very common used method. it returns exact date time from the system 

Example:

SELECT GETDATE() 

O/P

2012-07-17 15:37:12.420

Back