SQL> desc d_fx_deal;
Name Null? Type
----------------------------------------- -------- ----------------------------
EXCO_COMPANY VARCHAR2(4)
DRN_1 NOT NULL VARCHAR2(8)
VERSION_NUMBER NOT NULL NUMBER(10)
DRN_2 VARCHAR2(8)
DEAL_STATUS NUMBER(10)
DEAL_CONDITION NUMBER(10)
USER_1 VARCHAR2(10)
TIME_1 DATE
USER_2 VARCHAR2(10)
TIME_2 DATE
INCOMPLETE_CODE VARCHAR2(2)
USER_3 VARCHAR2(10)
TIME_3 DATE
INVOICE_FLAG_1_C NUMBER(10)
INVOICE_FLAG_2_C NUMBER(10)
CURR_REV_FLAG_C NUMBER(10)
DATE_1 DATE
SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';
Session altered.
SQL> select sysdate from dual;
SYSDATE
-------------------
2012-03-07 16:24:53
SQL> select date_1 from d_fx_deal where rownum < 10;
DATE_1
-------------------
2009-03-02 00:00:00
2009-03-02 00:00:00
2009-03-02 00:00:00
2009-03-02 00:00:00
2009-03-02 00:00:00
2009-03-02 00:00:00
2009-03-02 00:00:00
2009-03-02 00:00:00
2009-03-02 00:00:00
9 rows selected.
왜 계속 00:00:00으로 나올까요? |