How do I format a data in SQL to read like this: Monday, November, 23 2009
See Question&Answers more detail:osHow do I format a data in SQL to read like this: Monday, November, 23 2009
See Question&Answers more detail:osThe usual suspects:
DATE_FORMAT(t.date_column, '%W, %M, %d %Y')
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))
TO_CHAR(t.date_column, 'DAY, MONTH, DD YYYY')