$qr="select DATE_FORMAT(date_field,\"%Y-%d\") as fmt_date from table
$whereclause";

then grab 'fmt_date' from the results...



> Don´t really want to bother you with these quickies - but:
>
> If i have a result from mysql that is a date (2002-02-09) - how do i
change
> that into a variable with only the first 7 characters (2002-02)?
>




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to