Re: [PHP] One more quickie

2002-02-09 Thread Dennis Moore
$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

Re: [PHP] One more quickie

2002-02-09 Thread Edward van Bilderbeek - Bean IT
or: SELECT LEFT(date, 7) as YearAndMonth FROM table; Edward - Original Message - From: "val petruchek" <[EMAIL PROTECTED]> To: "PHP" <[EMAIL PROTECTED]> Sent: Saturday, February 09, 2002 2:28 PM Subject: Re: [PHP] One more quickie > > Don?

Re: [PHP] One more quickie

2002-02-09 Thread val petruchek
> 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)? > SELECT year(data), month (data) from table; Valentin Petruchek (aki Zliy Pes) *** Cut