Re: inserting due date into database
| From: | David Robley | Date: | Wed, 04 Jan 2006 08:39:02 +0000 |
| Subject: | Re: inserting due date into database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40964@lists.php.net to get a copy of this message | ||
On Wed, 4 Jan 2006 07:37, Ruprecht Helms wrote:
> Hi,
>
> how can I calculate the due date from the date of an invoice and
> insert the result into a mysql-database. The daydifference is 14 days.
>
> Actualy I have tried something with mktimes, but I only get the
> timestamp of the due date. I have troubles to write that into a
> dabasefield that was set to datetype.
>
> Regards,
> Ruprecht
You don't say what format the date is presented, but you could probably
look at doing the calculation with mysql's DATE_ADD; see
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
for more information.
Cheers
--
David Robley
Don't be a sexist, broads hate that.