RE: [PHP-DB] Pulling Date from MySQL then subtract
| From: | Bastien Koert | Date: | Sat, 22 Jan 2005 14:50:40 +0000 |
| Subject: | RE: [PHP-DB] Pulling Date from MySQL then subtract | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38263@lists.php.net to get a copy of this message | ||
you can use date-sub in the sql command (see the mysql manual) or use mktime() function in php
bastien
From: "Jess Hunter" <jlhunter@insightbb.com> To: <php-db@lists.php.net> Subject: [PHP-DB] Pulling Date from MySQL then subtract Date: Sat, 22 Jan 2005 08:37:56 -0600 I am needing some clarification on doing math with dates pulled from MySQL. The date format in the database is YYY-MM-DD and what I want to do is pull the date out, then add/subtract 30 days from the date. I have read through the manual, but for some reason, I'm just not getting it. Any help and/or examples would be greatly appreciated. Jess --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.832 / Virus Database: 566 - Release Date: 1/10/2005 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php