programming

sql

mysql

mariadb

subtract-days

[Edit]

MySql - subtract days from current date

2 contributors

7 contributions

0 discussions

16 points

Created by:

Emelia

517

In MySql, there is available DATE_ADD() function that helps to subtract days from some date. In this example we presented way how to subtract some days from current date.

1. `DATE_ADD()` with `NOW()` functions example

This example subtracts 30 days from current time.

SELECT DATE_ADD(NOW(), INTERVAL -30 DAY);

Result:

Subtract 30 days from current date operation in MySql with HeidiSQL.

Donate to Dirask

Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!

Direct link

Join to our subscribers to be up to date with content, news and offers.

MySQL - dates

MySQL - DATE, TIME, DATETIME, and TIMESTAMP differences

MySQL - DATEDIFF() function example

MySQL - DATE_FORMAT() function example

MySQL - HOUR() function example

MySQL - MINUTE() function example

MySQL - NOW() function example

MySQL - SECOND() function example

MySQL - TIMEDIFF() function example

MySQL - TIMESTEMP() function example

MySQL - WEEKDAY() and DAYOFWEEK() differences

MySQL - combine DATE and TIME column into TIMESTAMP

MySQL - combine DATE and TIME into TIMESTAMP

MySQL - compare datetime values

MySQL - convert date to month name

MySQL - convert date to weekday name

MySQL - convert date to weekday number

MySQL - count rows per day

MySQL - count rows per hour

MySQL - count rows per month

MySQL - count rows per year

MySQL - date to string (dd/mm/yyyy)

MySQL - difference between two dates

MySQL - difference between two datetimes

MySQL - difference between two time values

MySQL - extract HOUR from DATETIME / TIMESTAMP / TIME

MySQL - extract MINUTE from DATETIME / TIMESTAMP / TIME

MySQL - extract SECOND from DATETIME / TIMESTAMP / TIME

MySQL - get current date and time

MySQL - group datetime by time hour

MySQL - group rows by year

MySQL - select between two dates

MySQL - set current DATETIME as default

MySQL - strip time from datetime column

MySql - group rows by days

MySql - group rows by months

MySql - how to convert unix timestamp to datetime?

MySql - select rows with dates between

MySql - subtract days from current date

Native Advertising

🚀

Get your tech brand or product in front of software developers.

For more information Contact us

Dirask - we help you to

solve coding problems.

Ask question.

❤️💻 🙂

Join

1. DATE_ADD() with NOW() functions example