SQL Date Format

Question

How do I format a data in SQL to read like this: Monday, November, 23 2009

Answer 1

The usual suspects:

For MySQL:

DATE_FORMAT(t.date_column, '%W, %M, %d %Y')

DATE_FORMAT

For SQL Server:

DATENAME(dw, t.date_column) +', '+ DATENAME(mm, t.date_column) +', '+ CAST(DAY(t.date_column) AS VARCHAR(2)) +' '+ CAST(YEAR(t.date_column) AS VARCHAR(4))

DATENAME

For Oracle:

TO_CHAR(t.date_column, 'DAY, MONTH, DD YYYY')

TO_CHAR

Answer 2

This is for SQL Server (T-SQL)

SELECT DATENAME(dw,GETDATE()) + ', ' + DATENAME(MM, GETDATE()) + ', ' + CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4))

Just replace GETDATE() with the date variable

Learn more about DATENAME

Answer 3

Assuming you are using MySQL,

DATE_FORMAT(field_name, '%W, %M, %d %Y')

Answer 4

Which provider are you using? In SQL Server, it would be w/CONVERT. See here.