As of 7 AM on 9/3/2002, you should have access to the SA ...

Working with a query in which a date/time stamp field needed to be part of the selection criteria. Specifically, needed the scheduled query to run twice a day and pull data which had occurred within the past 12 hours. This calc works. TO_TIMESTAMP (TO_CHAR (SYSTIMESTAMP - 24/24, 'MM-DD-YYYY HH24'), 'MM-DD-YYYY HH24') ................
................