Date formatting problem

[eatc7402]

I have an Access table with a Date/Time field. That table is exported to MySql, and results in

a datetime field.

 

If I enter January 1, 2007 in Access, it shows up as 2007-01-01 00:00:00 after being exported.

 

I desire it to display as January 1, 2007 as I entered it originally. I have attempted to use

both the php date and gmdate function. The function do return a formatted date BUT NOT

the date I entered. They gmdate() returns January 1, 1970. date() returns December 31, 1969.

Hmmm.

 

$formatted_date = date("F j, Y", $date_test); where $date_test contains the field value

returned by a MySql query.

 

I must not be understanding the proper way to do this. Could someone LOWER

my level of ignorance please.

 

eatc7402

 

[sspoke]

could be you need to use mktime() on your $date_test

 

[kenrbnsn]

The date() function takes a UNIX timestamp as it's second argument, not a string. You need to use the function strtotime() to turn the string into an UNIX timestamp:

<?php
$date_test = '2007-01-01 00:00:00';
$formatted_date = date("F j, Y", strtotime($date_test));
echo $formatted_date;
?>

 

Ken

[eatc7402]

Yes,  that was the FIX. Now I see the reason. Thanks.

 

eatc7402