Feb 22, 2017 · How do I retrieve a date from SQL Server in YYYY-MM-DD format? I need this to work with SQL Server 2000 and up. Is there a simple way to perform this in SQL Server or …

Jun 25, 2013 · I have a query in SQL, I have to get a date in a format of dd/mm/yy Example: 25/jun/2013. How can I convert it for SQL server?

The source date (date in 101 format) is stored as a varchar initially, so I am guessing you would first need to convert it to a date type before changing it's format.

I have a date column in a table stored as MM/DD/YYYY format. I have to select and store the same date in another table in YYYY-MM-DD format i.e. XSD Date Format.

Jul 22, 2016 · If the datatype is date(time), the format shown is dependant on your local settings. Dates don't have an inherent format. If you want to display a particular format, you'll have to …

Please refer to "SQL Server", not "SQL", because different databases have different way to format dates.

Sep 2, 2013 · This is correct with regard to converting to date first, but 111 is for yyyy/mm/dd, the OP already has the right style (101).

Apr 1, 2009 · How do I use sql to get the whole month name in sql server? I did't find a way using DATEPART(mm, mydate) or CONVERT(VARCHAR(12), CreatedFor, 107). Basically I need in …

Dec 28, 2016 · I have a varchar column where some values are in mm/dd/yyyy format and some are in yyyymmdd. I want to convert all mm/dd/yyyy dates into the yyyymmdd format. What is …

Jan 8, 2014 · How do I convert a string to a date type in SQL Server 2008 R2? My string is formatted dd/mm/yyyy I tried this SELECT CAST('01/08/2014' AS DATE) But that does the …