SQL Server date function, SQL Server date

SQL Server date function, SQL Server date

Current System Date and Time

Select getdate ()

14:52:27. 123
Extract data from date

Day (), month (), year ()

Select getdate ();-14:52:27. 123
Select YEAR (getdate ();-2015
Select MONTH (getdate ();-6
Select day (getdate ();-18

Date Format Conversion
CONVERT

Select convert (char (19), getdate (), 120)

Export format: 2008-02-27
For details, refer to: MSDN

Date addition and subtraction
Select getdate ();-15:07:07. 770
Select dateadd (year,-1, getdate ();-15:07:07. 787
Operators and expressions