Get the first and last date of next month in MySQL

by

Use:

SELECT

DATE_SUB(
    LAST_DAY(
        DATE_ADD(NOW(), INTERVAL 1 MONTH)
    ), 
    INTERVAL DAY(
        LAST_DAY(
            DATE_ADD(NOW(), INTERVAL 1 MONTH)
        )
    )-1 DAY
) AS firstOfNextMonth,

LAST_DAY(
    DATE_ADD(NOW(), INTERVAL 1 MONTH)
)AS lastOfNextMonth

More Related Contents:

  1. Join vs. sub-query
  2. Find records from one table which don’t exist in another
  3. How do I update if exists, insert if not (AKA “upsert” or “merge”) in MySQL?
  4. Natural Sort in MySQL
  5. MySQL get row position in ORDER BY
  6. Comparing date ranges
  7. Subqueries vs joins
  8. MySQL Results as comma separated list
  9. MySQL unknown column in ON clause
  10. MySQL not using indexes with WHERE IN clause?
  11. SQL: Find the max record per group [duplicate]
  12. Group by month and year in MySQL
  13. calculate a sum of type time using sql
  14. MySQL: Transactions vs Locking Tables
  15. Remove duplicates using only a MySQL query?
  16. Select TOP X (or bottom) percent for numeric values in MySQL
  17. Group by date only on a Datetime column
  18. Finding the next available id in MySQL
  19. How exactly does using OR in a MySQL statement differ with/without parentheses?
  20. MySQL: How to copy rows, but change a few fields?
  21. How to renumber primary index
  22. Query that ignore the spaces
  23. Is it possible to have a default parameter for a mysql stored procedure?
  24. mysql automatically store record creation timestamp
  25. How to convert from varbinary to char/varchar in mysql
  26. update columns values with column of another table based on condition [duplicate]
  27. Update multiple rows with one query?
  28. MySQL: Count records from one table and then update another
  29. COUNT(id) vs. COUNT(*) in MySQL
  30. mysql GROUP_CONCAT duplicates

Leave a Comment