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.
