Date Formatting Question

space1

Hi there,

I'm trying to get a date stored in a MySql database to print out on my screen in PHP.

In the database, it's stored as:
2003-03-15 00:00:00

But I want it to print out in PHP like this:
Mar 15, 2003 Wed

This is what I have right now without any formatting:
<font face=verdana,arial size=1><strong>When:  </strong>" . $myrow['StartDate'] . ", "

Thanks for your help!

scoppc

$datetime="2003-03-15 00:00:00";

//separate date and time
$exp=explode(" ",$date);
$date=$exp[0];
$time=$exp[1];

//get the date parts
$exp1=explode("-",$date);
$year=$exp1[0];
$month=$exp1[1];
$day=$exp1[2];

//get the time
$exp2=explode(":",$time);
$hour=$exp2[0];
$min=$exp2[1];
$sec=$exp2[2];

$timestamp=mktime($hour,$min,$sec,$month,$day,$year);

//you can use date() to format the output
print date("M d, Y",$timestamp);

I havent test the code yet, give it a try.

zcketcher

No need to go through all that formating....simply have mysql return the date in the formation you want:

select date_format('2003-03-15 00:00:00', '%b %d, %Y %W');

...so in your query it would look something like:

select col1, col2, date_format(col3, '%b %d, $Y %W'), col4 from .... you get the idea.

Don't limit your research to the language your using...make sure to look for what's available to you in the apps your php code touches ..i.e. mysql. It can save you alot of code, time and headaches.

Here is the mysql link for date time functions:

http://www.mysql.com/doc/en/Date_and_time_functions.html

BTW: March 15th, 2003 was a Saturday....not a Wednesday