PHP Date

Anon

Hi,

Need some help please!

I have got: 23-04-2002 from my MySQl Datebase.

Is it possible to get the correct day of the week.

for example:
23-04-2002 --> Monday
17-05-2002 --> Friday

I have tryed with mktime but i was not sucessfull. Maybe the string "23-04-2002"?

thanks 4 any help
G

Anon

DAYNAME(date)

Returns the name of the weekday for date:
mysql> select DAYNAME("1998-02-05");
-> 'Thursday'

Bye Dave

p.s.: you can use also php function see date and mktime

Anon

Thanks,

But i need the php command.

With the string DD-MM-YYYY the mktime command does not create the correct output.

How do i use the mktime command do make:

17-05-2002 ==> Friday ?

thx

mikesgt2

try this:

$date = "17-05-2002"; // set date variable
list($day,$month,$year) = explode("-",$date); // get the day, month and year from it
$time = mktime(0,0,0,$month,$day,$year); // make a new timestamp
print date("l",$time); // print the weekday

Hope this helps.

mikesgt2

http://www.phpbuilder.com/manual/function.strtotime.php

would this work?