oracleÖÐʱ¼äÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

1.ÈÕÆÚ¸ñʽÖеġ°J¡±ºÍ¡°jsp¡±±íʾʲôÒâ˼£¿
select to_char(to_date(222,'J'),'jsp') from dual;
select to_char(to_date(222,'J'),'JSP') from dual;  
select to_char(to_date(222,'J'),'Jsp') from dual;  

2.¼ÆËã08Äê°ÂÔË»á(2008-08-08 20:00:00) ¾àÀ뵱ǰʱ¼äÒѹýÁ˶àÉÙÌì¶àÉÙСʱ¶àÉÙ·Ö¶àÉÙÃë? ÇóSQL!

---

SQL code:
SQL> --1¡¢Õâ¸öºÜÓÐÒâ˼£¬¿ÉÒÔ½«Êý×Öת»»³ÉÓ¢ÎÄ
SQL> SELECT to_char(to_date(222, 'J'), 'jsp') from dual;

TO_CHAR(TO_DATE(222,'J'),'JSP'
---------------------------------------------------------------------------
two hundred twenty-two

SQL> SELECT to_char(to_date(222, 'J'), 'JSP') from dual;

TO_CHAR(TO_DATE(222,'J'),'JSP'
---------------------------------------------------------------------------
TWO HUNDRED TWENTY-TWO

SQL> SELECT to_char(to_date(222, 'J'), 'Jsp') from dual;

TO_CHAR(TO_DATE(222,'J'),'JSP'
---------------------------------------------------------------------------
Two Hundred Twenty-Two

SQL> --2¡¢Ê±¼ä²î
SQL> WITH tt AS
2 (SELECT SYSDATE - to_date('2008-08-08 20:00:00', 'yyyy-mm-dd hh24:mi:ss') dt from dual)
3 SELECT '°ÂÔË»á¾à½ñÒѹý:' || trunc(dt) || 'Ìì' || trunc((dt - trunc(dt)) * 24) || 'Сʱ' ||
4 trunc((dt * 24 - trunc(dt * 24)) * 60) || '·Ö' || trunc((dt * 1440 - trunc(dt * 1440)) *
60) || 'Ãë' diff
5 from tt;

DIFF
-----------------