Pulling out year, month and day separately

Huuggee

I'm trying to separately pull out the day month and a year from a date entry.

The code is :

$query = "SELECT EXTRACT(year from $rlsdate)"; 
$result = mysql_query($query) or die ("Error in query $query. " . mysql_error());
echo "$result";

it must work to a point but returns

Resource id #3
and not the year as i hoped.

any help much appreciated

planetsim

I suggest taking a look in the Mysql manual
For Date_Format

maybe to 3 of those

one as day
then month
then year
or

another way..

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions

check that out

there should be curdate curmonth and curyear.. now that might help you

Huuggee

Thanx 🙂

you made me look at the same thing agan, and with a bit of jiggling i realised what was wrong

$query = "SELECT year(date), month(date), dayofmonth(date) from table";
$result = mysql_query($query) or die ("Error in query $query. " . mysql_error());
while($row = mysql_fetch_array($result)){
	$year=$row["year(date)"];
	$month=$row["month(date)"];
	$day=$row["dayofmonth(date)"];
echo "<P>$year $month $day";
}

So now i managed to separate all three, which is what i wanted

cheers