Mysql Date Previous Month

Mysql Date Previous Month is used to return the current and previous value of the month.

Understand with Example

The Tutorial illustrate an example that help you to describe Previous Month value. To understand this, we have a month (now( )) that return you current month value.

Query for finding current month:-

mysql> select month(now()) as CurrentMonth;

Output:-

+--------------+
| CurrentMonth |
+--------------+
|           12 |
+--------------+
1 row in set (0.00 sec)

Query for finding Previous month:-

Once you are able to find the current month, you can easily find the previous month before the current month. The Query month(now( )) -1 return you the previous month value precede the current month.

month(now( ))-1 : The month(now( )) -1 return you the previous month  before the current month.

mysql> select month(now())-1 as PreviousMonth;

Output:-

+---------------+
| PreviousMonth |
+---------------+
|            11 |
+---------------+
1 row in set (0.00 sec)

Related Tags for Mysql Date Previous Month:
c,  io,  help,  vi,  tutorial,  value,  ria,  example,  to,  exam,  e,  il,  month,  des,  m,  nt,  tr,  es,  rate,  describe,  tor,  xa,  xamp,  s,  at,  ha,  ll,  mpl,  pre,  str,  va,  tutor,  scr,  s,  s,  ri,  th,  st,  alu,  hat,  ple,  pl,  pr,  on,  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

Ask Questions?    Discuss: Mysql Date Previous Month  

Post your Comment

Your Name (*) :

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