When I search on Google for "dql doctrine unix_timestamp" I get 1.300.000
results. I only looked at the first 4, which all hint in the same
direction. You'll probably find a solution there. Please try that first,
before posting here. Thank you.
On Sunday, 16 February 2014 17:08:26 UTC+1, Parsifal wrote:
>
>
> I have difficulty to turn this sql in dq. please help I have a join_date
> coloumn in clients table (joinDate in entity), and it is a unix timestamp.
> now how to turn this in dql? for unix_timestamp I can use time() before dql
> line but how about the rest of it? if not possible how to turn it in
> NativeSQL?
>
>
> $dql = "SELECT month(from_unixtime(join_date)) AS month, count(*) AS
> signup, c_status AS status FROM clients WHERE join_date between
> unix_timestamp('{$year}-01-01') and unix_timestamp('{$year}-12-31
> 23:59:59') GROUP BY status, month";
>
>
--
You received this message because you are subscribed to the Google Groups
"doctrine-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/groups/opt_out.
