The Tutorial illustrate an example from the 'Sql Date and Time Format'. To understand this example we use the following syntax that is used to format date and time.

Sql Date and Time Format

     

The Tutorial illustrate an example from the 'Sql Date and Time Format'. To understand this example we use the following syntax that  is used to  format date and time.

 SYNTAX:- DATE_FORMAT(date,format)

date:-This is the field in  which we have specified date and time.

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
%r :-  This is used for showing Time, 12-hour (hh:mm:ss followed by AM or PM)

Query:-

The given below Date_Format(date,format) Query return you the format date in the order of Week,Day,Month,Year and time.

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

Output:-

Related Tags for Sql Date and Time Format:
sql,  syntax,  orm,  date,  form,  time,  sed,  format,  tutorial,  ria,  this,  for,  example,  to,  exam,  e,  il,  ax,  use,  im,  from,  in,  rm,  sta,  m,  nt,  tr,  tax,  me,  rate,  tor,  xa,  xamp,  s,  at,  is,  ha,  ime,  ll,  mpl,  follow,  and,  str,  wing,  tutor,  s,  s,  ri,  th,  st,  hat,  ple,  pl,  nd,  om,  ol,  o

More Tutorials from this section

• SQL Date, SQL Date Examples
• SQL Date
• MySQL By Date
• MySQL By Week
• Mysql date API
• Mysql Date Arithmetic
• Mysql Date in between
• Mysql Date Default
• Mysql date equal
• Mysql date field
• Mysql Date Filter
• Mysql Date Format codes
• Mysql Date Format Convert
• Mysql Date Format
• Mysql Date from Date
• Mysql Date and Time
• Mysql Date Functions
• Mysql Date Index
• Mysql Date Input
• Mysql Date To Java Date