Change the date format in SQLServer

Question

I have this small query

SELECT 
    MAX(myDate) AS DateToUser
FROM 
    blaTable

I'm getting this result "2011-05-23 15:18:01.223"

how can I get the result like 05/23/2011 "mm/dd/yyyy" format?

Vignesh Kumar A · Accepted Answer · 2014-03-01 11:14:19Z

1

Try this

SELECT 
   convert(varchar,MAX(myDate),101) AS DateToUser
FROM blaTable

If you are using SQL SERVER 2012 then Simple use FORMAT

SELECT 
    FORMAT(MAX(myDate),'MM/dd/yyyy') AS DateToUser
FROM blaTable

answered Mar 1, 2014 at 11:08

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

NiiL · Accepted Answer · 2014-03-01 11:05:23Z

0

SELECT
    convert(varchar, MAX(myDate), 101) AS DateToUser
FROM 
    blaTable

For more Date Format Parameters: Click Here

answered Mar 1, 2014 at 11:05

NiiL

2,8371 gold badge28 silver badges37 bronze badges

M.Ali · Accepted Answer · 2014-03-01 11:12:20Z

0

SELECT 
    CONVERT(VARCHAR(20),MAX(myDate),101) AS DateToUser
FROM 
    blaTable

For more information on Sql server datetime formats have a look here

answered Mar 1, 2014 at 11:05

M.Ali

69.9k17 gold badges110 silver badges133 bronze badges