[sql]DATE to Char

time zone

select to_char(sysdate, 'MON', 'NLS_DATE_LANGUAGE=american') from dual;


Reference:

http://sqle.ru/index.php/Oracle_PL/SQL/Date_Timezone/Date_Format#Change_the_original_date_format_in_the_TO_CHAR_function

http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/SQL52F46/Default.aspx

http://gogates.blogspot.tw/2011/09/use-of-nlsdatelanguage-parameter-in.html