From: | <dkuroki(at)dbas(dot)com(dot)ar> |
---|---|
To: | "Victor" <victor(dot)perez(at)e-evolution(dot)com>, "pgsql-es-ayuda(at)postgresql(dot)org" <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | Re: Conversion de Oracle a PostgreSQL Projecto Compiere |
Date: | 2005-07-13 12:17:41 |
Message-ID: | ZfenwKau.1121257061.9509460.dkuroki@dbas.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
En Postgres tenes que usar date_trunc() en lugar de trunc()
select date_trunc(text, timestamp)
text identifica que nivel queres truncar ( p/ ejplo 'day', 'hour',
etc)
Dorian Kuroki
DBAS Argentina
On 7/12/2005, "Victor" <victor(dot)perez(at)e-evolution(dot)com> wrote:
>Hola a todos!
>
>nuevamente pidiendo su ayuda para convertir esta sentencia de Oracle a
>PostgreSQL
>
>SELECT s.M_AttributeSetInstance_ID, asi.Description,
>asi.Lot, asi.SerNo, asi.GuaranteeDate, l.Value
>tyOnHand, s.QtyReserved, s.QtyOrdered,
>(TRUNC(asi.GuaranteeDate)-TRUNC(SysDate))-p.GuaranteeDaysMin,
>TRUNC(asi.GuaranteeDate)-TRUNC(SysDate), CASE WHE
>0 THEN
>TRUNC(((TRUNC(asi.GuaranteeDate)-TRUNC(SysDate))/p.GuaranteeDays)*100)
>ELSE 0 END FROM M_Storage s INNER JOIN M_Locator l ON
>(s.M_Locator_ID=l.
>JOIN M_Product p ON (s.M_Product_ID=p.M_Product_ID)
>LEFT OUTER JOIN M_AttributeSetInstance asi ON
>(s.M_AttributeSetInstance_ID=asi.M_AttributeSetInsta
>rehouse_ID=? AND s.M_Product_ID=? AND s.AD_Client_ID IN
>(0,11) AND (s.QtyOnHand<>0 OR s.QtyReserved<>0 OR
>s.QtyOrdered<>0) ORDER BY asi.GuaranteeDate,
>
>alguna sugerencia?
>
>Saludos
>Victor
>www.e-evolution.com
>
>---------------------------(fin del mensaje)---------------------------
>TIP 9: el optimizador ignorará el uso de recorridos de índice si los
> tipos de datos de las columnas no coinciden
From | Date | Subject | |
---|---|---|---|
Next Message | Damián Culotta | 2005-07-13 12:46:44 | Re: [pgsql-es-ayuda] Re:[pgsql-es-ayuda]Configuración PHP y Postgresqlpara windows |
Previous Message | Martín Marqués | 2005-07-13 09:44:34 | Re: Re: [pgsql-es-ayuda]Configuración PHP y Postgresql para windows |