check

Date format MS SQL

To format date as yyyy-mm-dd in MS SQL :

select convert(char(10),getdate(),121);
Result format : 2009-06-03
select convert(char(19),getdate(),121);
Result format : 2009-06-03 15:55:00