Posted on 2010-08-11 16:45
Justfly Shi 阅读(349)
评论(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