Divide by 60000 milliseconds for Interactive Q7 in SQL Server implementation
*/
select p_personid, p_firstname, p_lastname, l.l_creationdate, m_messageid,
COALESCE(m_ps_imagefile, m_content),
- DATEDIFF_BIG(millisecond,'1970-01-01',l.l_creationdate - m_creationdate)/60 as minutesLatency,
+ DATEDIFF_BIG(millisecond,'1970-01-01',l.l_creationdate - m_creationdate)/60000 as minutesLatency,
(case when exists (select 1 from knows where k_person1id = :personId and k_person2id = p_personid) then 0 else 1 end) as isnew
from
(select TOP(20) l_personid, max(l_creationdate) as l_creationdate
