²éѯÐÇÆÚ¼¸:
select to_char(sysdate,'day') from dual;
²éѯ¼¸ºÅ:
select to_char(sysdate,'dd') from dual;
²éѯСʱÊý:
select to_char(sysdate,'hh24') from dual;
²éѯʱ¼ä:
select to_char(sysdate,'hh24:mi:ss') from dual;
²éѯÈÕÆÚʱ¼ä:
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
²éѯÐÇÆÚ¼¸:
select to_char(to_date('2006-11-21','YYYY-MM-DD'),'DAY') from dual;
select to_char(to_date('2006-11-21','YYYY-MM-DD'),'DAY','NLS_DATE_LANGUAGE = American') from dual;
alter session set nls_date_language = 'simplified chinese';
ALTER SESSION SET NLS_DATE_LANGUAGE='AMERICAN';
²éѯÁ½¸öÈÕÆÚ¼äµÄÌìÊý:
FLOOR:·µ»ØµÈÓÚ»òСÓÚxµÄ×î´óÕûÊý:
select floor(to_date('20061121','yyyymmdd') - to_date('20061120','yyyymmdd')) from dual;
//»ñȡСʱ
SELECT EXTRACT(HOUR from TIMESTAMP '2005-10-10 10:10:10') from DUAL;
//»ñÈ¡Ô·Ý
SELECT EXTRACT(MONTH from SYSDATE) from DUAL;
//¼ÆËãÒ»Äê¶àÉÙÌì
select add_months(trunc(sysdate,'year'), 12) - trunc(sysdate,'year') from dual;
//×¢Ò⣺trunc(sysdate,'year')½ØÈ¡Éú³É==>'2006-01-01';
select trunc(sysdate,'year') from dual;
//²éѯһÄêÖеĵڼ¸Ìì
select TO_CHAR(SYSDATE,'DDD'),sysdate from dual;
next_day(sysdate,6)ÊÇ´Óµ±Ç°¿ªÊ¼ÏÂÒ»¸öÐÇÆÚÎå¡£ºóÃæµÄÊý×ÖÊÇ´ÓÐÇÆÚÈÕ¿ªÊ¼ËãÆð¡£
1 2 3 4 5 6 7
ÈÕ Ò» ¶þ Èý ËÄ Îå Áù
select next_day(to_date('2006-11-21','YYYY-MM-DD'),6);
//·µ»ØÒ»¸öÔ·ݵÄ×îºóÒ»Ìì
Select last_day(date'2006-02-01') D from dual£»
Select last_day(to_date('2006-02-01','YYYY-MM-DD')) from dual;
//·µ»ØÒ»¸öÔ·ݵÄ×îºóÒ»ÌìÊÇÐÇÆÚ¼¸
select to_char(last_day(to_date('2006-11-21','YYYY-MM-DD')),'DAY') from dual;
//»ñÈ¡ÉϸöÔÂÄ©Ì죺
select to_char(add_months(last_day(sysdate),-1),'yyyy-MM-dd') LastDay from dual;
==>×¢Òâ:last_day(sysdate)±íʾsysdateÕâ¸öÔµÄ×îºóÒ»Ìì
add_months(last_day(sysdate),-1)±íʾÉϸöÔµÄ×îºóÒ»Ìì
//ÉÏÔ½ñÌì
select to_char(add_months(sysdate,-1),'yyyy-MM-dd') PreToday from dual;
//ÉÏÔÂÊ×Ìì
select to_char(add_months(last_day(sysdate)+1,-2),'yyyy-MM-dd') firstDay from dual
ÓÐʱºòÍøÂç·¢Éú±ä¶¯£¬±ØÐëÊÖ¶¯ÐÞ¸ÄÒ»ÏÂRAC VIPµØÖ·£¬²»½öÊǵØÖ·£¬Ò²¿ÉÒÔÐÞ¸ÄVIPËùÔÚµÄÍø¿¨£¬ÔÔòÊÇVIPµØÖ·ÒªºÍPUBµØÖ·ÔÚͬһ¸öÍø¶ÎÄÚ£¬·½·¨ÆäʵÊDZȽϼòµ¥µÄ£¬ÓÐÈËÎʵ½£¬ÎÒ¸øÒ»¸öʾÀýÈçÏ£º
1¡¢¹Ø±ÕÊý¾Ý¿â
srvctl stop database -d db
2¡¢¹Ø±ÕNOTEAPPA
srvctl stop nodeapps -n db2
à ......
1.Ôø¾²»Ð¡ÐÄ°Ñ¿ª·¢¿âµÄÊý¾Ý¿â±íÈ«²¿É¾³ý£¬µ±Ê±ÏŵÄÒªËÀ¡£½á¹ûÕÒµ½ÏÂÃæµÄÓï¾ä»Ö¸´µ½ÁË1¸öСʱ֮ǰµÄÊý¾Ý£¡ºÜ¼òµ¥¡£
×¢ÒâʹÓùÜÀíÔ±µÇ¼ϵͳ£º
select * from ±íÃû as of timestamp sysdate-1/12 //²éѯÁ½¸öСʱǰµÄij±íÊý¾Ý£¡¼ÈÈ»Á½Ð¡Ê±ÒÔÇ°µÄÊý¾Ý¶¼µÃµ½ÁË£¬¼ÌÐøÔõô×ö£¬ÖªµÀÁË°É¡£¡£
Èç¹ûdropÁË±í£¬Ôõô°ì£¿£¿¼ûÏ ......