Date - Previous Day

[obrienkev]

Hi guys,

How do I insert into a database table the previous day's date?

e.g. Today is Thursday the 25th but I want Wednesday's date to be inserted.
How is this done?

$query = "INSERT INTO $table (name, size, type, content, file_date) ".
                 "VALUES ('$fileName', '$fileSize', '$fileType', '$content', NOW())";

Database date field: file_date(date)

[mrhappiness]

if http://www.phpbuilder.com/board/showthread.php?t=10306269 you found a way to add one day using DATE_ADD

sit down a minute und think about it: what might the fucntion be called to subtract one day?

hint: http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html lists them all

[obrienkev]

Yup. I already tried something like that...

$query="INSERT INTO notes values(NULL,'test', DATE_SUB(NOW()))";

But it didn't work.

Where am I going wrong?

thanks.

[mrhappiness]

in the thread i posted you wrote

DATE_ADD(NOW(), INTERVAL 1 DAY)

why do you not use the same scheme for DATE_SUB?

why do you not use the same scheme for DATE_SUB after having read the link to the mysql-manual?

did you read the mysql manual page i gave you?
did you read any of the links i posted?

[obrienkev]

Thanks again mrhappiness. This worked.

$query="INSERT INTO test values(NULL, 'test', DATE_SUB(NOW(), INTERVAL 1 DAY))";

Now how can I check if today is a Monday so that the date can be inserted as the previous Friday? i.e. need to leave out the weekends.

Is this possible?

Thanks.

Kevin.