Change DateTime format How can i return a date only format (DD/MM/YYYY) from a DateTime format column? example below

Modified Date
2007-09-01 02:00:00.000
2005-09-01 05:00:00.000


Output:

Date
09-01-2007
09-01-2005
If you are looking for a particular string formatting of a datetime data type value then you need to work with the convert() function with a particular style.  In this case, you are looking for the style with a value of 110 (resulting in the format of mm-dd-yyyy):

select convert(char(10), getdate(), 110);


(Note: I use getdate() just to generate a datetime value, in which case you would just reference your datetime column) My output is this:

06-08-2014