Re: newbie: how to return one iteration *per unique date(DAY!)* in a timestamp column?
| From: | Ben Dunlap | Date: | Wed, 05 Aug 2009 23:56:53 +0000 |
| Subject: | Re: newbie: how to return one iteration *per unique date(DAY!)* in a timestamp column? | ||
| References: | 1 2 3 4 5 6 7 8 9 10 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46419@lists.php.net to get a copy of this message | ||
>> Just one other tiny point of style here: having given the expression
>> date(solarAWDateTime) the alias uniqueDate, you should probably use
>> that alias to refer to the same thing elsewhere in your query, such as
>> in the GROUP BY column. So:
[8<]
> That's a mysqlism :( It's not portable to other db's (apparently it's
> not part of the sql-spec).
I think I've even seen MySQL reject it in some cases.
Ben