# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1372167242 -10800
# Node ID 7679a0100061e468a1ce17d15c31c39f6b345349
# Parent  187a673e7e1b5d00dffd5e95fac7a7f7dc9ad084
Adjust date format.

diff -r 187a673e7e1b -r 7679a0100061 oracle.rst
--- 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;
+