SQL Server gets date function format on day of month

Method One

The code is as follows
SELECT Convert (char (6), GETDATE (), 112)

Method Two

The code is as follows
SELECT * FROM table name where Convert (varchar (100), Date field, 23) = ' 2013-12-15 '

Use the CONVERT () function:

Select CONVERT (char (), GetDate (),) as Date

* The 3rd parameter is used to set the display style of date type data, the following describes the parameters of several styles:

MM DD yyyy

Mm/dd/yyyy

102 YYYY.MM.DD

Dd/mm/yyyy

YYYY dd MM

108 Hh:mi:ss (Time)

Yyyy/mm/dd

112 YYYYMMDD

Yyyy-mm-dd