Adjust date format.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 25 Jun 2013 16:34:02 +0300
changeset 1496 7679a0100061
parent 1495 187a673e7e1b
child 1497 c01be7e7545f
child 1503 6c23414696fe
Adjust date format.
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;
+