Get the date in YYYY-MM-DD format in SQL Server. September 7, 2016 by AbundantCode Leave a Comment You can retreive the date in the YYYY-MM-DD format in SQL Server using the CONVERT method as shown in this code snippet. How to get the date in YYYY-MM-DD format in SQL Server ? SELECT CONVERT(char(10), GetDate(),126) as abundantcodedate Related Content :How to get the date part from the date time in SQL Server ?What is the equivalent of MySQL's Now() function in SQL Server ?Date DisplayFormat for Textbox in ASP.NET MVCComparing only Date in the DateTime datatype in C#Using String.Format method in C# to add commas in thousands place for a NumberShare this:TweetLike this:Like Loading...
Leave a Reply