Originally posted by gbrabham
The following SQL gives you exactly 24 hours from the time the
trx is entered...

SELECT TO_CHAR(sysdate-1440/1440,'DD-MON-YY HH:MI:SS pm') FROM DUAL

Gregg
Isn't it same as SYSDATE-1 ??