| Subject | Re: [firebird-support] Re: Group by date on a timestamp field |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2005-12-16T07:16:25Z |
On 16 Dec 2005 at 6:57, ra8009 wrote:
GROUP BY.
--
SY, Dimitry Sibiryakov.
>Thanks Adam! Works great. Why can't I use something like:Because expressions in SELECT are calculated after expressions in
>
>select cast(myfieldname as Date) as SomeName, count(*)
>from mytablename
>group by SomeName
GROUP BY.
--
SY, Dimitry Sibiryakov.