Format date as 'DD Month YYYY'

Viewed 18719

Just have a mssql query that has a date in the format:

'2016-03-22 00:00:00.000' 

I need to format it as:

'22 March 2016'

I'm using SQL Server 2012. I've tried googling and the usual 106, 112 codes don't seem to work.

Is there a specific code format I can use?

6 Answers

how to change day month year in php

echo $purchase_date=date('F-Y',strtotime('2022-03-22 00:00:00.000'));

Ans// March-2022

how to change day month year in php Reverse date is changed in date formate - mysql database date

echo $date=date('d-m-Y',strtotime('2022-09-22'));

Ans// 22-09-2022

Related