Oracle Timestamp
CREATE TABLE TT
(
createTime TIMESTAMP NOT NULL
);
insert into TT values(to_timestamp('21NOV09 10:04:12.032','DDMONYY HH24:MI:SS.FF','nls_date_language=american'));
select * from TT;
select to_char(sysdate,'yy-mm-dd hh24:mi:ss') from dual //顯示:08-11-07 13:22:42
select to_date('2005-12-25,13:25:59','yyyy-mm-dd,hh24:mi:ss') from dual //顯示:2005-12-25 13:25:59
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/725820/viewspace-2154465/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle timestamp_to_scn and scn_to_timestampOracle
- oracle如何插入timestamp資料Oracle
- oracle的timestamp型別使用Oracle型別
- Oracle中的TIMESTAMP型別Oracle型別
- ORACLE TIMESTAMP資料型別Oracle資料型別
- oracle timestamp的最大值Oracle
- Oracle NLS_TIMESTAMP_FORMAT引數OracleORM
- Oracle中Date和Timestamp的區別Oracle
- Oracle中的TIMESTAMP資料型別Oracle資料型別
- oracle plsql定義date_timestamp_with time zoneOracleSQL
- C#插入Oracle中Timestamp型別資料C#Oracle型別
- oracle flashback特性(1.1)--閃回查詢之As of timestampOracle
- Oracle10g中SCN與TimeStamp轉換Oracle
- Sybase datetime型別對映為Oracle timestamp型別Oracle
- ORACLE DATE型別和TIMESTAMP型別DUMP換算Oracle型別
- oracle timestamp轉換date及date型別相減Oracle型別
- oracle 10g中scn和timestamp相互轉換Oracle 10g
- oracle資料型別date和timestamp的轉化Oracle資料型別
- mysql CURRENT_TIMESTAMP 和ON UPDATE CURRENT_TIMESTAMPMySql
- [Warning] TIMESTAMP with implicit DEFAULT --explicit_defaults_for_timestamp
- TIMESTAMP和TIMESTAMP WITH TIME ZONE之間的總結
- timestamp with local time zone型別和timestamp with time zone型別
- 如何提取oracle timestamp列一個範圍的資料Oracle
- partitioned by timestamp datatype
- MySQL之timestampMySql
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.explicit_defaults_for_timestamp
- 全面學習oracle flashback特性(1.1)--閃回查詢之As of timestampOracle
- ORACLE DATE和TIMESTAMP資料型別的比較(一) (轉)Oracle資料型別
- ORACLE DATE和TIMESTAMP資料型別的比較(二) (轉)Oracle資料型別
- JavaScript event.timeStampJavaScript
- jQuery event.timeStampjQuery
- 深入淺出timestamp
- 【徵文】全面學習oracle flashback特性(1.1)--閃回查詢之As of timestampOracle
- Oracle timestamp型別轉換date格式指令碼(精確到秒)Oracle型別指令碼
- 6、TIMESTAMP WITH TIME ZONE和TIMESTAMP WITH LOCAL TIME ZONE的實踐理解
- oracle之time zone時區timestamp with time zone相關的概念之一Oracle
- MySQL: datetime vs timestampMySql
- How to get SCN ,TIMESTAMP ,CHECKPOINT