Date Functions in SQL

-- SQL Server current system date and conversions -- getdate() function
SELECT Now=GETDATE() -- 2012-01-02 15:13:38.607

SELECT CONVERT(datetime, getdate()) -- 2012-01-02 15:13:38.607

SELECT CONVERT(datetime2, getdate()) -- 2012-01-02 15:13:38.6070000

SELECT CONVERT(smalldatetime, getdate()) -- 2012-01-02 15:14:00

SELECT CONVERT(date, getdate()) -- 2012-01-02

SELECT CONVERT(datetime, CURRENT_TIMESTAMP) -- 2012-01-02 15:13:38.607

-- SQL Server current system date functions
SELECT SYSDATETIME() -- 2012-01-02 15:13:38.6089121

,SYSDATETIMEOFFSET() -- 2012-01-02 15:13:38.6089121 +05:30

,SYSUTCDATETIME() -- 2012-01-02 09:43:38.6399152

,CURRENT_TIMESTAMP -- 2012-01-02 15:13:38.637

,GETDATE() -- 2012-01-02 15:13:38.637

,GETUTCDATE(); -- 2012-01-02 09:43:38.637

-- SQL Server current system date functions with conversions
SELECT CONVERT (datetime, SYSDATETIME()) -- 2012-01-02 15:13:38.640

,CONVERT (datetime, SYSDATETIMEOFFSET()) -- 2012-01-02 15:13:38.647

,CONVERT (datetime, SYSUTCDATETIME()) -- 2012-01-02 09:43:38.647

,CONVERT (datetime, CURRENT_TIMESTAMP) -- 2012-01-02 15:13:38.643

,CONVERT (datetime, GETDATE()) -- 2012-01-02 15:13:38.643

,CONVERT (datetime, GETUTCDATE()); -- 2012-01-02 15:13:38.643