在Oracle中插入具有特定日期和时间格式的值

Question

我尝试将值插入survey.ysg表（在insert查询中使用）

INSERT INTO SURVEY.YSG(YSG_ID,YSG_MSN_DTM,TAX_ID,TAX_NM,TYPE_CD,USER_ID,
                       FRST_NM,LAST_NM,SHL_TXT,NPR_DT, PHONE_NBR,FAX_NBR,
                       EMAIL_ADRS_TXT,YSG_IMD,MDFD_ID,YSG_VRFCTN_CD,
                       YSG_VRFCTN_DTM,LOG_KEY,PLS_DTM,LOAD_KEY,UPDTD_LOAD_KEY ) 
   VALUES ( '103','2011-08-11 13:34:36.000000','656002075',
           'STG HEALTH SYSTEM','null','OPLINKS4','UNK','UNK','UNK',
           '12/31/8888','UNK','UNK','UNK','X','UNK','Y','8888-12-31 00:00:00.000000',
           0,'2011-07-20 12:00:00.000000',0,0)

错误报告：SQL错误：ORA-01843:无效月份01843。00000-“无效月份”*原因:
*操作：

YSG_MSN_DTM - TIMESTAMP(6)

NPR_DT - DATE

YSG_VRFCTN_DTM - TIMESTAMP(6)

PLS_DTM - TIMESTAMP(6)

TO_DATE('2011-08-11 13:34:36','YYYY-MM-DD HH24:MI:SS')  

感谢您的任何帮助。

谢谢

Answer 1

试试这个：

INSERT INTO
      SURVEY.YSG ( YSG_ID,
                YSG_MSN_DTM,
                TAX_ID,
                TAX_NM,
                TYPE_CD,
                USER_ID,
                FRST_NM,
                LAST_NM,
                SHL_TXT,
                NPR_DT,
                PHONE_NBR,
                FAX_NBR,
                EMAIL_ADRS_TXT,
                YSG_IMD,
                MDFD_ID,
                YSG_VRFCTN_CD,
                YSG_VRFCTN_DTM,
                LOG_KEY,
                PLS_DTM,
                LOAD_KEY,
                UPDTD_LOAD_KEY )
VALUES
      ( '103',
        TO_TIMESTAMP ( '2011-08-11 13:34:36.000000',
                    'YYYY-MM-DD HH24:MI:SS.FF' ),
        '656002075',
        'STG HEALTH SYSTEM',
        'null',
        'OPLINKS4',
        'UNK',
        'UNK',
        'UNK',
        TO_DATE ( '12/31/8888',
                'MM/DD/YYYY' ),
        'UNK',
        'UNK',
        'UNK',
        'X',
        'UNK',
        'Y',
        TO_TIMESTAMP ( '8888-12-31 00:00:00.000000',
                    'YYYY-MM-DD HH24:MI:SS.FF' ),
        0,
        TO_TIMESTAMP ( '2011-07-20 12:00:00.000000',
                    'YYYY-MM-DD HH24:MI:SS.FF' ),
        0,
        0 );