Mysql Date Format

Ads
 

Mysql Date Format

Mysql Date Format explains you the way of formatting Date.

Mysql Date Format explains you the way of formatting Date.

Mysql Date Format

     

Mysql Date Format explains you the way of formatting Date.

Understand with Example

The Tutorial elaborate an example from 'Mysql Date Format'. To understand this example we show you the following Syntax used for formatting the date :

SYNTAX:-DATE_FORMAT(date,format)

date:-This is the date which is to been formatted.

format:-The format specifier used here are

%W:-   This is used for showing weekday name i.e(Sunday-Saturday).
%e:- 
This is used for showing Day of the month, numeric (0-31).
%M :-
This is used for showing Month name (January-December)
%Y:- 
This is used for showing Year, numeric, four digits

Query:-

SELECT DATE_FORMAT('2008-12-15', '%W %e %M %Y');

Output:-

Ads

Ads