SQL SERVER date conversion

The default datetime format of the Chinese version of SQL Server is yyyy-mm-dd Thh: mm: ss. mmm.


For example:

Program code

Select getdate ()


11:06:08. 177

The date format conversion method that may be frequently used in SQL Server:


Example:

Select CONVERT (varchar, getdate (), 120)

11:06:08


Select replace (CONVERT (varchar, getdate (), 120 ),'-',''),'',''),':','')

20040912110608


Select CONVERT (varchar (12), getdate (), 111)

2004/09/12


Select CONVERT (varchar (12), getdate (), 112)

20040912


Select CONVERT (varchar (12), getdate (), 102)

2004.09.12

Other uncommon date format conversion methods:


Program code select CONVERT (varchar (12), getdate (), 101)

09/12/2004


Select CONVERT (varchar (12), getdate (), 103)

12/09/2004


Select CONVERT (varchar (12), getdate (), 104)

12.09.2004


Select CONVERT (varchar (12), getdate (), 105)

12-09-2004


Select CONVERT (varchar (12), getdate (), 106)

12 09 2004


Select CONVERT (varchar (12), getdate (), 107)

09 12,200 4


Select CONVERT (varchar (12), getdate (), 108)

11:06:08


Select CONVERT (varchar (12), getdate (), 109)

09 12, 2004 1


Select CONVERT (varchar (12), getdate (), 110)

09-12-2004


Select CONVERT (varchar (12), getdate (), 113)

12 09 2004 1


Select CONVERT (varchar (12), getdate (), 114)

11:06:08. 177