可以用;
1-5部分是好的;
第6部分有乱码
------------------------------------------
µÚÁù²¿·Ö¡¢ORACLEʱ¼ä´¦Àí¼°ÆäËû
¶ÔoracleÖÐʱ¼äÔËËãÌáÎʵÄÎÊÌâ
ÄÚÈÝÈçÏ£º
1¡¢oracleÖ§³Ö¶ÔÈÕÆÚ½øÐÐÔËËã
2¡¢ÈÕÆÚÔËËãʱÊÇÒÔÌìΪµ¥Î»½øÐеÄ
3¡¢µ±ÐèÒªÒÔ·ÖÃëµÈ¸üСµÄµ¥Î»Ëãֵʱ£¬°´Ê±¼ä½øÖƽøÐÐת»»¼´¿É
4¡¢½øÐÐʱ¼ä½øÖÆת»»Ê±×¢Òâ¼ÓÀ¨ºÅ£¨¼ûʾÀýÖкìÉ«À¨ºÅ£©£¬·ñÔò»á³öÎÊÌâ
SQL> alter session set nls_date_format='yyyy-mm-dd hh:mi:ss';
»á»°ÒѸü¸Ä¡£
SQL> set serverout on
SQL> declare
2 DateValue date;
3 begin
4 select sysdate into DateValue from dual;
5 dbms_output.put_line('Դʱ¼ä:'||to_char(DateValue));
6 dbms_output.put_line('Դʱ¼ä¼õ1Ìì:'||to_char(DateValue-1));
7 dbms_output.put_line('Դʱ¼ä¼õ1Ìì1Сʱ:'||to_char(DateValue-1-1/24));
8 dbms_output.put_line('Դʱ¼ä¼õ1Ìì1Сʱ1·Ö:'||to_char(DateValue-1-1/24-1/(24*60)));
9 dbms_output.put_line('Դʱ¼ä¼õ1Ìì1Сʱ1·Ö1Ãë:'||to_char(DateValue-1-1/24-1/(24*60)-1/(24*60*6
0)));
10 end;
11 /
——————————————————————————————————————————————————————————