oracel中date类型的变量输入格式是什么呀? insert into ...values (to_date('20040322','yyyymmdd') ... 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT SYSDATE FROM DUAL 对照一下不就清楚 SQL> SELECT * FROM V$NLS_PARAMETERS;PARAMETER VALUE---------------------------------------------------------------- ----------------------------------------------------------------NLS_LANGUAGE SIMPLIFIED CHINESENLS_TERRITORY CHINANLS_CURRENCY RMBNLS_ISO_CURRENCY CHINANLS_NUMERIC_CHARACTERS .,NLS_CALENDAR GREGORIANNLS_DATE_FORMAT DD-MON-RRNLS_DATE_LANGUAGE SIMPLIFIED CHINESENLS_CHARACTERSET ZHS16GBKNLS_SORT BINARYNLS_TIME_FORMAT HH.MI.SSXFF AMNLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZMNLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZMNLS_DUAL_CURRENCY RMBNLS_NCHAR_CHARACTERSET AL16UTF16NLS_COMP BINARYNLS_LENGTH_SEMANTICS BYTENLS_NCHAR_CONV_EXCP FALSE19 rows selected alter system set NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'; insert 时先 to_date or to_char 为你要的日期格式如 "YYYYMMDD","YYYY/MM/DD" 看看注册表中oracle的 NLS_DATE_FORMAT的键值就是默认的日期格式。可修改它,如:“YYYY/MM/DD HH24:MI:SS”没有,可增加 NLS_DATE_FORMAT 查找表中最新一条数据 初学oracle sql问题 寻熟悉ORACLE FORM的高手 oracle执行效率问题 新建视图无法显示问题 asp.net连接oracle时出现ORA-12638: 凭证检索失败,是怎么回事呢。急! Oracle9i.中国it实验室的远程教学ocp录像 bt下载 出血者的问题:怎样在本地创建oracle数据库? Oracle ORA-02069: 此操作的 global_names 参数必须设置为 TRUE 数据导出问题 求助:PHP如何远程连接oracle数据库,,
对照一下不就清楚
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY RMB
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY RMB
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE19 rows selected
可修改它,如:“YYYY/MM/DD HH24:MI:SS”
没有,可增加 NLS_DATE_FORMAT