requete mysql vers postgreSQL
Bonjour,
J'ai cette requete faite en mysql qui ne fonctionne pas sous postgreSQL:
Code:
1 2 3 4 5 6 7 8 9 10 11
| SELECT AVG(wo.TIMEREQ)/1000 as moyenne, COUNT(*) as nb
FROM WorkO wo
LEFT JOIN Work wos ON wo.WORKID=wos.WORKID
LEFT JOIN CatDef cd ON wos.CATID=cd.CATID
LEFT JOIN StatDef std ON wos.STID=std.STID
LEFT JOIN WorkO_Q wo_q ON wo.WORKID=wo_q.WORKID
LEFT JOIN QueueDef q ON wo_q.QID=q.QID
LEFT JOIN PriorityDef pd ON wos.PRIOID=pd.PRIOID
WHERE (wo.RESOLVTIME BETWEEN UNIX_TIMESTAMP('".$date_borne[0]." 00:00:00')*1000
AND UNIX_TIMESTAMP('".$date_borne[1]." 23:59:59')*1000)
AND wo.DEPARTID = 1 |
J'ai essayé de la "convertir" avec ce code:
Code:
1 2 3 4 5 6 7 8 9 10 11 12
|
SELECT AVG(wo.TIMEREQ)/1000 as moyenne, COUNT(*) as nb
FROM WorkO wo
LEFT JOIN Work wos ON wo.WORKID=wos.WORKID
LEFT JOIN CatDef cd ON wos.CATID=cd.CATID
LEFT JOIN StatDef std ON wos.STID=std.STID
LEFT JOIN WorkO_Q wo_q ON wo.WORKID=wo_q.WORKID
LEFT JOIN QueueDef q ON wo_q.QID=q.QID
LEFT JOIN PriorityDef pd ON wos.PRIOID=pd.PRIOID
WHERE (wo.RESOLVTIME (select extract(epoch from timestamp '".$date_borne[0]." 00:00:00') * 1000))
AND (select extract(epoch from timestamp '".$date_borne[1]." 23:59:59') * 1000) ) )
AND wo.DEPARTID = 1 |
Mais j'ai toujours cette erreur:
Citation:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "extract"
LINE 10: WHERE (wo.RESOLVEDTIME extract(epoch from timestamp '2...
Pourriez vous m'aider pour régler ce problème? merci