Date formatting with PHP

Anon

Hi,

I get date value from a MySQL table using a "date" kind of field in table, so when a print the date in the documents it is resulting like : AAAA-MM-DD .

What I would like to do is show it like:

DD-MM-AAAA

I have see the "date" function in PHP, but is this the solution for my needs ?

And if yes, how should I use it with the var value I take from MySQL table ?

Something like :

date($buyingdate,dmY); ?

It doesn't work...

Thank you!

Anon

Since MySQL is already giving you the date as a string in
the format AAAA-MM-DD, all you need to do is explode() the
string on the '-' and then rearrange the array elements as
needed for your desired date order.

Anon

As kirk parker mentioned, you can explode the date into parts.

Here is an example code:

$mydate = "AAAA-MM-DD"; // get this from the mysql table
$mydate_parts = explode("-", $mydate);
$my_new_date = $mydate_parts[2] . "-" . $mydate_parts[1] . "-" . mydate_parts[0];

// Thats all, now when you access $my_new_date, it should give in the form of DD-MM-AAAA.

hope this helps,
-sridhar

Anon

Many thanks to both of you for the helpfull solutions !!

Fabio

Anon

I like extracting it from the database formatted:

$sql="SELECT *, DATE_FORMAT(date, '%e %b %Y') AS fdate FROM ............."

My problem is not getting the dates out and dsiplay format, but rather the converse...

searching the date field whe it is in the database!

I have tried variations of "WHERE date = 2001-05-13" and "WHERE date = 20010513" wh=ith no luck.

As saw references to:
"WHERE date LIKE '2001-05-13%'"
and variations on that.

Any advice on why I cannot search by the date field!?!?

Thanks!

Anon

By the way, realise I never followed-up on this.
As for my wee problem, I think it may have been caused by using the word "date" as the field name. is this a reserveed word?

Anyway, changed the field name and it is now fine.

using "WHERE date = '2001-05-13'" could that have been asking for the current date to be equal to '2001-05-13'?

Anon

for further date formatting:
do something like this

$mydate=$my_mysql_fetch_array(mysql_query("SELECT * FROM story"))["myDatefield"];

$mydate_inparts= explode("-", $mydate);

echo date ("l, F d, Y", mktime (0,0,0,$dt_inparts[1],$dt_inparts[2],$dt_inparts[0]));

results in something close to=" Thursday, January 24, 2002 "