Oracle Timestamp

zchbaby2000發表於2018-05-14

                   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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章