SQL date formatting

The default datetime format of the Chinese version of SQL Server is yyyy-mm-dd thh: mm: Ss. Mmm.

For example:

Select getdate () => 2012-02-22 11:10:36. 570

I sorted out the date format conversion methods that may be frequently used in SQL Server:

Example:

Select convert (varchar, getdate (), 120)

2012-02-22 11:06:08

Select Replace (replace (convert (varchar, getdate (), 120 ),'-',''),'',''),':','')

20120222110608

Select convert (varchar (22), getdate (), 111)

Select convert (varchar (22), getdate (), 112)

20120222

Select convert (varchar (22), getdate (), 102)

2012.02.22

Select convert (varchar (22), getdate (), 101)

02/22/2012

Select convert (varchar (22), getdate (), 103)

22/02/2012

Select convert (varchar (22), getdate (), 104)

22.02.2012

Select convert (varchar (22), getdate (), 105)

22-02-2012

Select convert (varchar (22), getdate (), 106)

22 02 2012

Select convert (varchar (22), getdate (), 107)

02, 22,201 2

Select convert (varchar (22), getdate (), 108)

11:06:08

Select convert (varchar (22), getdate (), 102)

02 22, 2012 1

Select convert (varchar (22), getdate (), 110)

02-22-2012

Select convert (varchar (22), getdate (), 113)

22 02 2012 1

Select convert (varchar (22), getdate (), 114)

11:06:08. 177