SQL Server: Current Date in SQL Server format yyyy-mm-dd

Current Date in SQL Server format yyyy-mm-dd

SELECT convert(varchar(30), cast(getdate() as date), 120) 

2014-11-05