Dear Irm Jr,
Here are two functions::
http::/www.php.net/strtotime
http::/www.php.net/mktime
using these functions togethor you can do the need
full.
BTW why not store just unix time stamp in mysql
database. Most People use a string field in mysql
database to store timestamp, it simply work wit
Thanks for the replies. I believe I have two solutions now!
Take care. Much apprecitated.
-Original Message-
From: Swan, Nicole [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 28, 2004 2:48 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] php mysql dates
I would suggest creating
Specialist
Carroll College CCIT
(406)447-4310
-Original Message-
From: Justin Patrin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 28, 2004 3:44 PM
To: Irm Jr
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] php mysql dates
On Wed, 28 Jul 2004 14:39:01 -0700, Irm Jr <[EMAIL PROTECTED]>
ay to deal with that, IMHO, is strtotime and date.
$mysqlDate = date('Y-m-d', strtotime($month.' '.$day.', '.$year));
If you're using dates far in the past or future, though, this won't
work. Better to use a date handling class, such as:
http://pear.p
Sure I understand Y-m-d. But won't the database cry because the Month
is in text format? (January, february)? Thanks again.
Subject: Re: [PHP-DB] php mysql dates
On Wed, 28 Jul 2004 14:30:24 -0700, Irm Jr <[EMAIL PROTECTED]> wrote:
>
> Hi all, currently I have a form
Hi all, currently I have a form which prompts for the user to choose a
date. The dropdown lists are stored into variables:
$month//e.g. January, February, ...
$day //e.g 1 - 31
$year //e.g. 2004 (four digits)
then combined into
$articleDate
How can I manipulat