Mega Code Archive
Categories
/
MSSQL Tutorial
/
Data Convert Functions
CONVERT(char(10), GETDATE(), 112)
3> CREATE TABLE my_date (Col1 datetime) 4> GO 1> 2> INSERT INTO my_date VALUES (CONVERT(char(10), GETDATE(), 112)) 3> GO (1 rows affected) 1> 2> drop table my_date; 3> GO