Posted on 2010-08-11 16:45
Justfly Shi 閱讀(368)
評論(0) 編輯 收藏 所屬分類:
tips
It is only available for one session.
using the below command before you run your query
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
For more information, refer to the page http://www.oracle.com/technology/products/database/sql_developer/howtos/howto_policy_date_formats.html