Oracle ÖÐµÄ TO_DATE ºÍ TO_CHAR º¯Êý
oracle ÖÐ TO_DATE º¯ÊýµÄʱ¼ä¸ñʽ£¬ÒÔ 2008-09-10 23:45:56 ΪÀý
¸ñʽ
˵Ã÷
ÏÔʾֵ
±¸×¢
Year(Äê):
yy
two digits(Á½Î»Äê)
08
yyy
three digits(ÈýλÄê)
008
yyyy
four digits(ËÄλÄê)
2008
Month(ÔÂ):
mm
number(Á½Î»ÔÂ)
09
mon
abbreviated(×Ö·û¼¯±íʾ)
9ÔÂ
ÈôÊÇÓ¢ÎÄ°æ, ÔòÏÔʾ sep
month
spelled out(×Ö·û¼¯±íʾ)
9ÔÂ
ÈôÊÇÓ¢ÎÄ°æ, ÔòÏÔʾ september
Day(ÈÕ):
dd
number(µ±Ôµڼ¸Ìì)
10
ddd
number(µ±ÄêµÚ¼¸Ìì)
254
dy
abbreviated(µ±Öܵڼ¸Ìì¼òд)
ÐÇÆÚÈý
ÈôÊÇÓ¢ÎÄ°æ, ÔòÏÔʾ wed
day
spelled out(µ±Öܵڼ¸Ììȫд)
ÐÇÆÚÈý
ÈôÊÇÓ¢ÎÄ°æ, ÔòÏÔʾ wednesday
ddspth
spelled out, ordinal twelfth
tenth
Hour(ʱ):
hh
two digits(12Сʱ½øÖÆ)
11
hh24
two digits(24Сʱ½øÖÆ)
23
Minute(·Ö):
mi
two digits(60½øÖÆ)
45
Second(Ãë):
ss
two digits(60½øÖÆ)
56
ÆäËû:
Q
digit(¼¾¶È)
3
WW
digit(µ±ÄêµÚ¼¸ÖÜ)
37
W
digit(µ±Ôµڼ¸ÖÜ)
2
˵Ã÷£º
12Сʱ¸ñʽÏÂʱ¼ä·¶Î§Îª£º 1:00:00 - 12:59:59(12 СʱÖÆÏ嵀 12:59:59 ¶ÔÓ¦ 24 СʱÖÆÏ嵀 00:59:59)
24Сʱ¸ñʽÏÂʱ¼ä·¶Î§Îª£º 0:00:00 - 23:59:59
1. ÈÕÆÚºÍ×Ö·ûת»»º¯ÊýÓ÷¨£¨to_date,to_char£©
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual; //ÈÕÆÚת»¯Îª×Ö·û´®
select to_char(sysdate,'yyyy') as nowYear from dual; //»ñȡʱ¼äµÄÄê
select to_char(sysdate,'mm') as nowMonth from dual; //»ñȡʱ¼äµÄÔÂ
select to_char(sysdate,'dd') as nowDay from dual; //»ñȡʱ¼äµÄÈÕ
select to_char(sysdate,'hh24') as nowHour from dual; //»ñȡʱ¼äµÄʱ
select to_char(sysdate,'mi') as nowMinute from dual; //»ñȡʱ¼äµÄ·Ö
select
Ïà¹ØÎĵµ£º
ɾ³ýAIXϵÄORACLE
===========================================================
×÷Õß: wmlm(http://wmlm.itpub.net)
·¢±íÓÚ:2008.12.02 18:17
·ÖÀà: oracle
³ö´¦£ºhttp://wmlm.itpub.net/post/12871/474762
---------------------------------------------------------------
rm -Rf /etc/oratab
rm -Rf /et ......
1.ÔÚOracle ÖУ¬Äã»áÁ˽⵽£º
ÊÂÎñÊÇÿ¸öÊý¾Ý¿âµÄºËÐÄ£¬ËüÃÇÊÇ“ºÃ¶«Î÷”¡£
Ó¦¸ÃÑÓ³Ùµ½Êʵ±µÄʱ¿Ì²ÅÌá½»¡£²»ÒªÌ«¿ìÌá½»£¬ÒÔ±ÜÃâ¶Ôϵͳ´øÀ´Ñ¹Á¦¡£ÕâÊÇÒòΪ£¬Èç¹û
ÊÂÎñºÜ³¤»òºÜ´ó£¬Ò»°ã²»»á¶ÔϵͳÓÐѹÁ¦¡£ÏàÓ¦µÄÔÔòÊÇ£ºÔÚ±ØҪʱ²ÅÌá½»£¬µ«ÊÇ´ËÇ°²»ÒªÌá
½»¡£ÊÂÎñµÄ´óСֻӦ¸Ã¸ù¾ÝÒµÎñÂß¼À´¶¨¡£
Ö»ÒªÐèÒ ......
ORACLE
CREATE OR REPLACE FUNCTION SETSTATE(OLDVALUE VARCHAR2, POS NUMBER, SVALUE VARCHAR2)
RETURN VARCHAR2
IS
RETURN_VALUE VARCHAR2 (20);
LEN NUMBER(8);
I NUMBER(8);
TEMP_VALUE VARCHAR2(1);
BEGIN
LEN := LENGTH(OLDVALUE);
IF POS > ......
×î½üÔÚÏîÄ¿±¨±íÖÐÐèÒªÒ»¸ö²éѯÓï¾ä£¬ÓÃÀ´Í³¼Æ·ûºÏijһÁÐÌõ¼þµÄÆäËü¼¸ÁеĸöÊý
±ÈÈçÓÐÏÂÃæÒ»¸ö±í½á¹¹£º
ÐèÒªÔÚÁÐDºóÃæÔö¼ÓÒ»ÁУ¬Í³¼ÆÔÚÁÐA²»Îª¿Õ£¬²¢ÇÒÁÐB¡¢C¡¢D²»Îª¿ÕµÄ¸öÊý
¾¹ý×Ô¼ºÊÔÑ飬²éÕÒ°ïÖú£¬×ÜËãʵÏÖÁËÉÏÃæµÄ²éѯ¡£
&nb ......
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
²ÎÊý1 IN NUMBER,
²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......