Change Date Format (DD / MM / YYYY) in SQL SELECT Statement

Question

Original SQL statement:

SELECT SA.[RequestStartDate] as 'Service Start Date', 
       SA.[RequestEndDate] as 'Service End Date', 
FROM
(......)SA
WHERE......

The output date format is YYYY / MM / DD, but the output date format is DD / MM / YYYY. How can I change this statement?

Answer 1

Try it...

select CONVERT (varchar(10), getdate(), 103) AS [DD/MM/YYYY]

For more information: http://www.sql-server-helper.com/tips/date-formats.aspx

Answer 2

Changed to:

SELECT FORMAT(SA.[RequestStartDate],'dd/MM/yyyy') as 'Service Start Date', SA.[RequestEndDate] as 'Service End Date', FROM (......)SA WHERE......

You can’t imagine which SQL engine you are using, for another SQL engine in the SELECT statement you can use CONVERT to change the format in the form you need.

Answer 3

CONVERT().

:

SELECT CONVERT(VARCHAR(10), SA.[RequestStartDate], 103) as 'Service Start Date', CONVERT(VARCHAR(10), SA.[RequestEndDate], 103) as 'Service End Date', FROM (......) SA WHERE.....

. MSDN Cast and Convert.

Answer 4

Try:

SELECT convert(nvarchar(10), SA.[RequestStartDate], 103) as 'Service Start Date', 
       convert(nvarchar(10), SA.[RequestEndDate], 103) as 'Service End Date', 
FROM
(......)SA
WHERE......

:

SELECT format(SA.[RequestStartDate], 'dd/MM/yyyy') as 'Service Start Date', 
       format(SA.[RequestEndDate], 'dd/MM/yyyy') as 'Service End Date', 
FROM
(......)SA
WHERE......

Answer 5

this-

select TO_CHAR(SA.[RequestStartDate] , 'DD/MM/YYYY') as RequestStartDate from ... ;