To keep date/time format in USA standard add this to front of query: select Batch, to_char(BurstTime, 'MM/DD/YYYY HH24:MI:SS') AS bursttime For example select Batch, to_char(BurstTime, 'MM/DD/YYYY HH24:MI:SS') AS bursttime from getbearings('20-Oct-2004 10:31:00', '20-Oct-2004 10:33:00', null, null, 65)