PHP Dates

PHP date

[danno13]

i have a string that looks like this:
$date="2002-07-04";

how can i find out what weekday this date falls on?

[jatar_k]

$date = getdate("2002-07-04");
$dayofweek = $date["weekday"];
echo $dayofweek;

<added>sorry

Welcome to WebmasterWorld danno13

[jatar_k]

posted too quickly, that doesn't actually work but this does

$datestamp=mktime(0,0,0,4,7,2002);
$date = getdate($datestamp);
$dayofweek = $date["weekday"];
echo $dayofweek;

mktime [php.net] and getdate [php.net]

then you just have to get your date into the above format.

[jatar_k]

OK, I've been messing around, this seems to work

$datestr = "2002-07-08";
$datearr = explode("-", $datestr);
$datestamp=mktime(0,0,0,$datearr[1],$datearr[2],$datearr[0]);
$date = getdate($datestamp);
$dayofweek = $date["weekday"];
echo $dayofweek;

[danno13]

The following is the code i am using to test this. i am not getting the correct output. The lines that begin with"$datestamp=mktime" give me different results.

// Get the Formatted DATE for the invoice number from the orders table
$query = "SELECT DATE_FORMAT(invoiceDate, '0,0,0,%m,%d,%Y') FROM orders WHERE invoiceNumber=" . $invoiceNumber;
$resultDate = @mysql_query($query);

$rowDate = mysql_fetch_array($resultDate);

$formatedDate = $rowDate["DATE_FORMAT(invoiceDate, '0,0,0,%m,%d,%Y')"];
echo "<br>formatedDate = " . $formatedDate; //** this line prints - formatedDate = 0,0,0,07,15,2002

//$datestamp=mktime(0,0,0,07,15,2002); //** when i use this line i get the correct output , monday
$datestamp=mktime($formatedDate); //** when i use this line i get tuesday
echo "<br>datestamp= " . $datestamp;
$date = getdate($datestamp);
echo "<br>date = " . $date;
$dayofweek = $date["weekday"];
echo "<br>" . $dayofweek;

[danno13]

thanks, jatar_k

that one works great.

[jatar_k]

there also seems to be a mysql function

DAYOFWEEK [mysql.com]