开发者

How to Subtract Days in MySQL

开发者 https://www.devze.com 2023-01-24 03:54 出处:网络
How can I subtract time in MySQL? For example, today is 16 March; I want to subtract 15 days to reach 1 March. Are there any methods that can be used to su开发者_如何转开发btract 15 days from the curr

How can I subtract time in MySQL? For example, today is 16 March; I want to subtract 15 days to reach 1 March. Are there any methods that can be used to su开发者_如何转开发btract 15 days from the current date?


SELECT DATE(NOW()-INTERVAL 15 DAY)

For a list of units see http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add


Not entirely related to this question but is related to the title:

SELECT SUBTIME("10:24:21", "5");        -- subtracts 5 seconds. (returns "10:24:16")

SELECT SUBTIME("10:24:21", "01:00:00");  -- subtracts one hour. (returns "09:24:21")

Documentation: MySQL SUBTIME function


Use:

SELECT NOW() - INTERVAL 15 DAY

to keep the datetime precision.


You can use this :

SELECT DATE(NOW()-INTERVAL 15 DAY);

for when you want to subtract the number of days.

In order to subtract the time instead, say 15 minutes, the following should work:

SELECT(DATE_SUB(NOW(), INTERVAL '15:0' MINUTE_SECOND));

Adding the reference link again :- https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-add.


Yes its possible using date function in Mysql

    select distinct
 lastname, 
      changedat, date_add(changedat, interval -15 day) as newdate
from employee_audit;

lastname and changedat is field name and employee_audit is table name.

How to Subtract Days in MySQL

I have subtract 15 days from my date - check image please. thanks

0

精彩评论

暂无评论...
验证码 换一张
取 消