Porting Oracle Date Manipulation
- by Grasper
I need to port this following from Oracle syntax to Postgresql. Both FLO_END_DT and FLO_START_DATE are of type DATE in Oracle, and TIMESTAMP WITHOUT TIME ZONE in Postgresql:
SELECT
TRUNC( TO_CHAR(ROUND(( FL.FLO_END_DT- FL.FLO_START_DT)* 24), '9999D99'),2)
FROM
FLOWS FL
I am not familiar enough with Oracle to know what it is trying to accomplish.
Any ideas?