Is there a function to get the date in sql?

zilong17

The time of the database is 2016-12-12 16:04:42
I want to take only the date. Is there such a function? If not, what should I do?

cv4bf5d65fd

select convert (char (10), getdate (), 21)

prajna

getdate ()

kittast

select convert (char (8), getdate (), 112)
or
select convert (char (10), getdate (), 120)

hiqwolfzzh

lz check the online help search for ‘CONVERT’

There is a very detailed table of conversion methods in various time formats ^ _ ^

fanfan1980

select convert (char (10), getdate (), 120)