Oracleʱ¼ä¼ÆËã
ÈÕÆÚ¸ñʽ²ÎÊý º¬Òå˵Ã÷
D Ò»ÖÜÖеÄÐÇÆÚ¼¸
DAY ÌìµÄÃû×Ö£¬Ê¹ÓÿոñÌî³äµ½9¸ö×Ö·û
DD ÔÂÖеĵڼ¸Ìì
DDD ÄêÖеĵڼ¸Ìì
DY ÌìµÄ¼òдÃû
IW ISO±ê×¼µÄÄêÖеĵڼ¸ÖÜ
IYYY ISO±ê×¼µÄËÄλÄê·Ý
YYYY ËÄλÄê·Ý
YYY,YY,Y Äê·ÝµÄ×îºóÈý룬Á½Î»£¬Ò»Î»
HH Сʱ£¬°´12Сʱ¼Æ
HH24 Сʱ£¬°´24Сʱ¼Æ
MI ·Ö
SS Ãë
MM ÔÂ
Mon Ô·ݵļòд
Month Ô·ݵÄÈ«Ãû
W ¸ÃÔµĵڼ¸¸öÐÇÆÚ
WW ÄêÖеĵڼ¸¸öÐÇÆÚ
1.ÈÕÆÚʱ¼ä¼ä¸ô²Ù×÷
µ±Ç°Ê±¼ä¼õÈ¥7·ÖÖÓµÄʱ¼ä
select sysdate,sysdate - interval ’7’ MINUTE from dual
µ±Ç°Ê±¼ä¼õÈ¥7СʱµÄʱ¼ä
select sysdate - interval ’7’ hour from dual
µ±Ç°Ê±¼ä¼õÈ¥7ÌìµÄʱ¼ä
select sysdate - interval ’7’ day from dual
µ±Ç°Ê±¼ä¼õÈ¥7ÔµÄʱ¼ä
select sysdate,sysdate - interval ’7’ month from dual
µ±Ç°Ê±¼ä¼õÈ¥7ÄêµÄʱ¼ä
select sysdate,sysdate - interval ’7’ year from dual
ʱ¼ä¼ä¸ô³ËÒÔÒ»¸öÊý×Ö
select sysdate,sysdate - 8 *interval ’2’ hour from dual
2.ÈÕÆÚµ½×Ö·û²Ù×÷
select sysdate,to_char(sysdate,’yyyy-mm-dd hh24:mi:ss’) from dual select sysdate,to_char(sysdate,’yyyy-mm-dd hh:mi:ss’) from dual select sysdate,to_char(sysdate,’yyyy-ddd hh:mi:ss’) from dual select sysdate,to_char(sysdate,’yyyy-mm iw-dhh:mi:ss’) from dual
²Î¿¼oracleµÄÏà¹Ø¹ØÎĵµ(ORACLE901DOC/SERVER.901/A90125/SQL_ELEMENTS4.HTM#48515)
3. ×Ö·ûµ½ÈÕÆÚ²Ù×÷
select to_date(’2003-10-17 21:15:37’,’yyyy-mm-dd hh24:mi:ss’) from dual
¾ßÌåÓ÷¨ºÍÉÏÃæµÄto_char²î²»¶à¡£
4. trunk/ ROUNDº¯ÊýµÄʹÓÃ
select trunc(sysdate ,’YEAR’) from dual select trunc(sysdate ) from dual select to_char(trunc(sysdate ,’YYYY’),’YYYY’) from dual
5.oracleÓкÁÃë¼¶µÄÊý¾ÝÀàÐÍ
--·µ»Øµ±Ç°Ê±¼ä ÄêÔÂÈÕСʱ·ÖÃëºÁÃë select to_char(current_timestamp(5),’DD-MON-YYYY HH24:MI:SSxFF’) from dual; --·µ»Øµ±Ç° ʱ¼äµÄÃëºÁÃ룬¿ÉÒÔÖ¸¶¨ÃëºóÃæµÄ¾«¶È(×î´ó=9) select to_char(current_timestamp(9)
Ïà¹ØÎĵµ£º
µ±OracleµÄ¶à¸ö´æ´¢¹ý³Ì¶¼Ê¹Óù«¹²µÄ³£Á¿Ê±£¬ÎÒÃÇ¿ÉÒÔ½¨Ò»¸öרÃŵÄpackageÓÃÀ´¹ÜÀíËùÓеij£Á¿¡£¶¨ÒåµÄʾÀý´óÖÂÈçÏ£º¡¡
create or replace package GLOBAL_CONSTANT is
/*ÊýÖµÀà³£Á¿*/
/*±ÈÂÊ*/
rate_tax CONSTANT NUMBER := 1.17; -- ˰ÂÊ   ......
Ê×ÏÈÕÒµ½Â·¾¶£º
E:\Oracle Enterprise_Standard Edition_11.1.0.7\database\stage\prereq\db\refhost.xml
ÈçϽڵ㣺
<!--Microsoft Windows Vista-->
<OPERATING_SYSTEM>
<VERSION VALUE="6.0"/>
</OPERAT ......
Ò»¡¢Íü¼Ç³ýSYS¡¢SYSTEMÓû§Ö®ÍâµÄÓû§µÄµÇ¼ÃÜÂë¡£
ÓÃSYS (»òSYSTEM)Óû§µÇ¼¡£
CONN SYS/PASS_WORD AS SYSDBA;
ʹÓÃÈçÏÂÓï¾äÐÞ¸ÄÓû§µÄÃÜÂë¡£
ALTER USER user_name IDENTIFIED BY newpass;
......
ORACLEµÄ·ÖÇø(Partitioning Option)ÊÇÒ»ÖÖ´¦Àí³¬´óÐͱíµÄ¼¼Êõ¡£·ÖÇøÊÇÒ»ÖÖ“·Ö¶øÖÎÖ®”µÄ¼¼Êõ£¬Í¨¹ý½«´ó±íºÍË÷Òý·Ö³É¿ÉÒÔ¹ÜÀíµÄС¿é£¬´Ó¶ø±ÜÃâÁ˶Ôÿ¸ö±í×÷Ϊһ¸ö´óµÄ¡¢µ¥¶ÀµÄ¶ÔÏó½øÐйÜÀí£¬Îª´óÁ¿Êý¾ÝÌṩÁË¿ÉÉìËõµÄÐÔÄÜ¡£·ÖÇøÍ¨¹ý½«²Ù×÷·ÖÅ䏸¸üСµÄ´æ´¢µ¥Ôª£¬¼õÉÙÁËÐèÒª½øÐйÜÀí²Ù×÷µÄʱ¼ä£¬²¢Í¨¹ýÔöÇ¿µÄ²¢Ðд ......
ÎÊÌâÃèÊö£º
µ±Êý¾Ý¿âµÄ×Ö·û¼¯ÎªÖÐÎÄʱ£¬timestampÀàÐ͵Ä×Ö¶ÎΪÒÔϸñʽ£º
04-3ÔÂ -10 03.57.41.631000 ÏÂÎç
ÎÒÔÚÓÃJDOM½«Êý¾Ýµ¼³öΪXMLʱ£¬timestampÀàÐÍ×ֶεÄÖµ·´ÉúÁ˱仯£¬±ä³ÉÁËһϸñʽ
<CREATE_DATE>2010-3-4.15.57. 30. 505000000</CREATE_DATE>
½â¾ö·½°¸£º
ÔÚ²éѯ¸Ã×Ö¶ÎʱÊ×ÏÈÓÃto_char£¨£©º¯Êý½ ......