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 …

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.

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?

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

May 6, 2010 · I've got a similar situation where the date is being held as a string in a UK format with slashes on SQL 2012 (dd/mm/yyyy). The only thing which works for me is CONVERT …

I have a string '2009-06-24 09:52:43.000', which I need to insert to a DateTime column of a table. But I don't care about the time, just want to insert it as 2009-06-24 00:00:00.000 How can I do ...

– user330315 Jul 22, 2016 at 8:11 Please edit the question and indicate what data type the dates are, i.e. date, datetime, varchar etc. – Nick.Mc May 23, 2023 at 8:02

Dec 28, 2016 · Actual date / datetime -valued columns don't have a format. Do you mean to say you have columns which contain textual representations of dates in char / varchar columns?

Applying to_date() on a date column makes no sense. Also date columns are not stored "with a format". The format is applied by the client application (e.g. SQL*Plus) when displaying the date.

Oct 27, 2010 · 90 I have a datetime column in SQL Server that gives me data like this 10/27/2010 12:57:49 pm and I want to query this column but just have SQL Server return the day month …