--- a/oracle.rst Thu Jun 20 11:36:23 2013 +0300
+++ b/oracle.rst Tue Jun 25 16:34:02 2013 +0300
@@ -131,3 +131,18 @@
==============================
* http://docs.oracle.com/cd/B19306_01/em.102/b40103/app_oracle_reserved_words.htm
+
+Adjust date format.
+===================
+::
+
+ column parameter format a32;
+ column value format a32;
+ select parameter, value from v$nls_parameters;
+
+ alter session set NLS_DATE_FORMAT = 'yyyy-mm-dd HH:MI:SS';
+ alter session set NLS_TIMESTAMP_FORMAT = 'MI:SS.FF6';
+ alter session set NLS_TIME_FORMAT = 'HH24:MI:SS.FF6';
+
+ select sysdate from dual;
+