In Buy Shipment Query Screen, how can I get OTM to use local time on a search?

 We are trying to give the users the ability to query Shipments that shipped for a given date or date range. 

 

We thought to use the Actual Departure Date at stop 1 on the Shipment Stop.  These fields were added to our custom Buy Shipment Screen.

 

If I wanted to see all shipments that shipped yesterday, When you put in a date, 2009-11-02 for the actual departure in the Buy Shipment Query Screen,  OTM generates a query with the following in the where clause

 

.... where (sstop.actual_departure between trunc(TO_DATE('2009-11-02 05:00:00','YYYY-MM-DD HH24:MI:SS'), 'MI') and trunc(TO_DATE('2009-11-02 05:00:00','YYYY-MM-DD HH24:MI:SS'), 'MI')+0.99999)