Can Oracle convert date/time values such as '03-NOV-2001 15:50' to GMT (or UTC) which for me is -11 hours from my local time?
I thought I could do this by: select to_char(date_occurred,'DD-MON-YYYY HH24:MI', 'GMT') from report but I got an invalid NLS parameter error... Thanks in advance, Stacy.