A format that permanently changed the date of Oracle database

xiaoxiao2021-03-06  40

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the partitioning, OLAP AND ORACLE DATA MINING OPTIONS

JServer Release 9.2.0.4.0 - Production

SQL> SELECT SYSDATE from DUAL;

Sysdate

---------

30-DEC-04

SQL> Host Export NLS_DATE_FORMAT = "YYYY-MM-DD HH24: MI: SS"

SQL> SELECT SYSDATE from DUAL;

Sysdate

---------

30-DEC-04

SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the partitioning, OLAP AND ORACLE DATA MINING OPTIONS

JServer Release 9.2.0.4.0 - Production

[Oracle @ TZXD Oracle] $ EXPORT NLS_DATE_FORMAT = "YYYY-MM-DD HH24: MI: SS"

[Oracle @ TZXD ORACLE] $ SQLPLUS "/ as sysdba"

SQL * Plus: Release 9.2.0.4.0 - Production on Thu Dec 30 20:10:39 2004

CopyRight (C) 1982, 2002, Oracle Corporation. All Rights Reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the partitioning, OLAP AND ORACLE DATA MINING OPTIONS

JServer Release 9.2.0.4.0 - Production

SQL> SELECT SYSDATE from DUAL;

Sysdate

-------------------

2004-12-30 20:10:46

SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the partitioning, OLAP AND ORACLE DATA MINING OPTIONS

JServer Release 9.2.0.4.0 - Production

[Oracle @ TZXD ORACLE] $

转载请注明原文地址:https://www.9cbs.com/read-66758.html

New Post(0)