converting date into database date format(newbie)

[Binay Agarwal]

Hi!

U can convert "8-Aug-03" into mysql date which requires yyyy-mm-dd format as
below.

<?php
date("Y-m-d",strtotime("8-Aug-03"));

?>

Hope this helps and let me know.

Cheers

Binay

----- Original Message -----
From: "Anil Garg" <anilg@niksun.com>
To: <php-general@lists.php.net>
Sent: Friday, August 29, 2003 11:01 AM
Subject: [PHP] converting date into database date format(newbie)

> Hi,
>
> I am a newbie to php.
>
> I am reading date in the format "08-Aug-03" from a text file. While

writing

> this date into the myqsl database's date column it shows '00-00-0000'.
> Is there a function or some other way to convert "08-Aug-03" type of dates
> in to format which is acceptable by date field of the mysql database.
>
> Thanks and regards
> Anil.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

[Anil Garg]

Hi,

I am a newbie to php.

I am reading date in the format "08-Aug-03" from a text file. While writing
this date into the myqsl database's date column it shows '00-00-0000'.
Is there a function or some other way to convert "08-Aug-03" type of dates
in to format which is acceptable by date field of the mysql database.

Thanks and regards
Anil.

[John W. Holmes]

Anil Garg wrote:

> I am reading date in the format "08-Aug-03" from a text file. While writing
> this date into the myqsl database's date column it shows '00-00-0000'.
> Is there a function or some other way to convert "08-Aug-03" type of dates
> in to format which is acceptable by date field of the mysql database.

MySQL expects it's date in a YYYY-MM-DD or YYYYMMDD format. Try using
soething like this:

$mysql_date = date('Ymd',strtotime($date_from_text_file));

--
---John Holmes...

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

php|architect: The Magazine for PHP Professionals – [url]www.phparch.com[/url]