How to implement this query using Zend_Db?

Question

SELECT
name,
(CASE due WHEN ' ' THEN ' ' ELSE FROM_UNIXTIME(due/1000000) END) AS 'due',
(CASE due WHEN ' ' THEN ' ' ELSE DATEDIFF(NOW(), FROM_UNIXTIME(due/1000000)) END) AS 'Day Ago',
(CASE due WHEN ' ' THEN ' ' ELSE FROM_UNIXTIME(completed/1000000) END) AS 'completed',
description
FROM milestone
WHERE DATEDIFF(NOW(), FROM_UNIXTIME(due/1000000) > 1;

Tomáš Fejfar · Accepted Answer · 2011-03-25 16:35:36Z

1

$dbAdapter->query($sqlQuery)

Where $sqlQuery contains the string you posted :) Far te easiest solution for such a complex query ;) Or

$db->select()
   ->from('milestone', array(new Zend_Db_Expr($stringBetweenSelectAndFrom)))
   ->where('DATEDIFF(NOW(), FROM_UNIXTIME(due/1000000) > 1);

answered Mar 25, 2011 at 16:35

Tomáš Fejfar

11.2k8 gold badges58 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to implement this query using Zend_Db?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related