Re: One more quickie
| From: | Dennis Moore | Date: | Sat, 09 Feb 2002 14:15:06 +0000 |
| Subject: | Re: One more quickie | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-84102@lists.php.net to get a copy of this message | ||
$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)?
>