PHP Need to subtract day from MySQL date

[strangist]

Hi,

I a working with PHP MySQL environment & I need to subtract a day or say 2 days from a date. Now the problem is how to apply the logic to deduct days from start_date?
PHP Need to subtract day from MySQL date
Can anyone please help me out?
Thanks in advance.

[beanboy]

Try this:

$date = "1999-05-22";
$newdate = strtotime ( '-3 day' , strtotime ( $date ) ) ;
$newdate = date ( 'Y-m-j' , $newdate );
 
echo $newdate;

[Janus]

You can also use Use DATE_SUB in the WHERE clause.

DATE_SUB(date,INTERVAL expr unit)

[Darth]

Mysql Date Subtract

Mysql Date Subtract is used to find the date between the current date and the date before the current date.

We use select DATE_SUB(curdate(),INTERVAL 1DAY) that return you date one day before the current date.
DATE_SUB(curdate(),INTERVAL DAY) : The Query is used to return the date before the current date. The INTERVAL is used to subtract the number of days specified in interval from the current date

Query to subtract from date

select DATE_SUB(curdate(), INTERVAL 1 DAY);