Date In/Output

Anon

Hi,

I've got a field in MySQL which holds information like 2001-04-02

On the page, I want to take out of the database '2001' and 'April'

The 2001 is no problem, but how do I tell PHP or MySQL that I want to get the full text month 'April' as output instead of '04'

I really can't figure it out, I hope you can help.

Mika

craigh

how about:

$monthlist=array('jan', 'feb', 'mar' ..etc..);
$date="2001-04-02";
list ($year, $monthpointer, $day) = split ('-', $date);
$month=$monthlinst[$monthpointer];

I have no idea if this will actually work, but it might be worth trying.

webmaster02

Fix me if Im wrong, but I dont think that MySQL can handle dates any other way. You could just replace that date with a timestamp(in Epoch Form), ie: 986371200 then you could convert it later in PHP using the date() function...

like this:

//here you would get the info from your DB
$date = "986371200";
$mdy = date("m/d/y", $date);
//PHP will then convert your epoch time into m/d/y or what ever else you need.

Just to explain for you non unix users, Epoch time is the number of seconds elapsed since December 31, 1969. This is helpful because it contains all sorts of data,
month, date, day, year, hours, minutes, seconds, etc...

Hope this helps.

Brad Taylor
Senior Web Producer
BradCom Industries LTD
brad_at_getcoded.net(replace the at with @)

weldoncj

Use the date_format function of Mysql. (look up the exact reference in the Mysql manual), but

date_format(date,\'%W\')
should output the date as a month.

and
date_format(date,\'%W %M %e, %Y\') will output
Saturday May 19, 2001

So it would be:
SELECT date_format(date,\'%W\') as date2 where date=\'2001-04-01\';

your date2 variable will now be April.