MySQL’s now() +1 day

by

You can use:

NOW() + INTERVAL 1 DAY

If you are only interested in the date, not the date and time then you can use CURDATE instead of NOW:

CURDATE() + INTERVAL 1 DAY

More Related Contents:

  1. generate days from date range
  2. Create date from day, month, year fields in MySQL
  3. Mysql strip time component from datetime
  4. How to change string date to MySQL date format at time of import of CSV using MySQL’s LOAD DATA LOCAL INFILE
  5. How to return only the Date from a SQL Server DateTime datatype
  6. MySQL Insert query doesn’t work with WHERE clause
  7. Delete from two tables in one query
  8. Get day of week in SQL Server 2005/2008
  9. Fulltext Search with InnoDB
  10. SQLite – ORDER BY RAND()
  11. Preventing adjacent/overlapping entries with EXCLUDE in PostgreSQL
  12. Delete sql rows where IDs do not have a match from another table
  13. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  14. What does DELIMITER // do in a Trigger?
  15. Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
  16. MySQL equivalent of DECODE function in Oracle
  17. How do you version your database schema? [closed]
  18. MySQL, Get users rank
  19. Mysql: how to select groups having certain values?
  20. How to fill date gaps in MySQL?
  21. Boolean vs tinyint(1) for boolean values in MySQL
  22. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  23. Function for week of the month in mysql
  24. how to cast the hexadecimal to varchar(datetime)?
  25. How to use Timestamp_to_scn and Scn_to_timestamp in Oracle?
  26. Find rows that have the same value on a column in MySQL
  27. what is the difference between GROUP BY and ORDER BY in sql
  28. How to find all IDs of children recursively?
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment