Mysql last day of month

The Tutorial illustrate an example from 'Mysql Last Day of Month'. To  understand and grasp the example we run LAST_DAY(now( )) that return the last day of the month.

LAST_DAY(now( )) : The Query return the last day of the current month a s fieldname Last Day of Month.

Query:

mysql> SELECT DAY(LAST_DAY(now())as LastDayOfMonth;

Output:-

+----------------+
| LastDayOfMonth |
+----------------+
|             31 |
+----------------+
1 row in set (0.00 sec)

Related Tags for Mysql last day of month:
sql,  mysql,  asp,  tutorial,  return,  ria,  example,  to,  exam,  run,  ast,  e,  il,  month,  last,  from,  no,  as,  sta,  m,  nt,  tr,  rate,  day,  tor,  xa,  xamp,  s,  urn,  sp,  at,  ras,  my,  ha,  ll,  mpl,  and,  str,  tutor,  s,  s,  ri,  th,  st,  hat,  grasp,  ple,  pl,  nd,  on,  om,  o

More Tutorials from this section

• MySQL Addition
• MySQL Add Column
• MySQL Aggregate Function
• MySQL Append
• MySql Append Codes
• MySQL Append Column
• MySQL Append Data
• MySQL Append String
• SQL Functions
• Mysql Difference
• Mysql Group By
• Mysql last day of month
• Mysql Last Record
• Mysql last row
• Mysql Last
• Mysql Left Function
• Mysql Left
• Mysql Length Function
• Mysql String Length
• Mysql Like Command

Ask Questions?    Discuss: Mysql last day of month  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):