Pulling Date from MySQL then subtract

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

RE: Pulling Date from MySQL then subtract

you can use date-sub in the sql command (see the mysql manual) or use
mktime() function in php

bastien

>From: "Jess Hunter"
>To:
>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
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Pulling Date from MySQL then subtract

Jess Hunter wrote:
> 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.

SELECT yourdatecolumn - INTERVAL 30 DAY FROM yourtable WHERE ...

--

---John Holmes...

Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals – www.phparch.com

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php