使ç¨oracleå
ç½®å½æ°to_timestampå°±å¯ä»¥äº
select to_timestamp('1700','HH24MI') from dual
1ãå符å转ætimestamp代ç å¦ä¸:
select to_timestamp('01-10æ-08 07.46.41.000000000 ä¸å','dd-MON-yy hh:mi:ss.ff AM')
from dual;
2ãtimestamp转ædateå
代ç å¦ä¸:
select cast(to_timestamp('01-10æ-08 07.46.41.000000000 ä¸å','dd-MON-yy hh:mi:ss.ff AM') as date) timestamp_to_date
from dual;
3ãdateå转ætimestamp
代ç å¦ä¸:
select cast(sysdate as timestamp) date_to_timestamp
from dual;
4ãè·åtimestampæ ¼å¼çç³»ç»æ¶é´
代ç å¦ä¸:
select systimestamp from dual;
5ã两dateçæ¥æç¸åå¾åºçæ¯å¤©æ°ï¼è两timestampçæ¥æç¸åå¾åºçæ¯å®æ´çå¹´ææ¥æ¶åç§å°æ°ç§
代ç å¦ä¸:
select systimestamp-systimestamp from dual;
select sysdate-sysdate from dual;
注ï¼æ以ï¼timestampè¦ç®åºä¸¤æ¥æé´éäºå¤å°ç§ï¼è¦ç¨å½æ°è½¬æ¢ä¸ä¸ã
6ãto_charå½æ°æ¯ædateåtimestampï¼ä½æ¯truncå´ä¸æ¯æTIMESTAMP
æ°æ®ç±»åã
7ãtimestampåªæ¯æç§çå°æ°ç¹åé¢å
ä½ã
代ç å¦ä¸:
select to_char(systimestamp, 'yyyymmdd hh24:mi:ssxff6') FROM dual;
注ï¼ssxff6ä¹å¯ä»¥ä¸ºssxff7ãssxff8ãssxff9çï¼ä½åªå°6ææã
8ãè·åç³»ç»æ¶é´çè¯å¥ï¼
代ç å¦ä¸:
SELECT sysdate,systimestamp,to_char(systimestamp, 'yyyymmdd hh24:mi:ssxff6') FROM dual;