Set Time Zone for Select statement

view full story

http://www.daniweb.com – I am writting a query in SQL Developer. I have a field in the table that holds a timezone. I need to set the query to use that timezone. Any ideas? Here's the query I have so far: select to_char(dateoftransport, 'MM-DD-YYYY') as "Date",   dispatch_id as "Dispatch,   vehicletype as "Dispatch Type" from progamgh.dispatch where patients >= 1 and   dateoftransport >= to_date('01-01-2010', 'MM-DD-YYYY') and   dateoftransport <= to_date('01-31-2010', 'MM-DD-YYYY') (General)