timestamp with local timezone和dbtimezone

botang

1. --hr
   
2. select dbtimezone from dual;
   
3. 
   
4. select sessiontimezone from dual;
   
5. 
   
6. select  to_timestamp('2010-01-10 12:00:00', 'YYYY-MM-DD HH24:MI:SS'  ) from dual;
   
7. 
   
8. create table t07110_a(  a  date, b  timestamp,  
   
9.   c timestamp with time zone, d timestamp with local time zone,location varchar2(20)  );
   
10. 
    
11. insert into t07110_a values(sysdate,sysdate,sysdate,sysdate,'Shanghai1');
    
12. commit;
    
13. 
    
14. select  * from t07110_a;
    
15. 
    
16. insert into t07110_a      values(current_date,current_date,current_date,current_date,'Shanghai-2');
    
17. commit;
    
18. 
    
19. select  * from t07110_a;
    
20. 
    
21. --sys
    
22. select  * from dict_columns c where c.column_name  like '%TZ%';
    
23. 
    
24. select  * from V$TIMEZONE_NAMES;
    
25. 
    
26. --hr
    
27. insert into t07110_a values(to_date('2010-01-10 15:02:00','YYYY-MM-DD HH24:MI:SS'),
    
28.                    to_timestamp('2010-01-10 15:02:00','YYYY-MM-DD HH24:MI:SS'),
    
29.                    to_timestamp_tz('2010-01-10 15:02:00 +0:0','YYYY-MM-DD HH24:MI:SS TZH:TZM'),
    
30.                    to_timestamp_tz('2010-01-10 15:02:00 +0:0','YYYY-MM-DD HH24:MI:SS TZH:TZM'),
    
31.                    'Shanghai3');
    
32. commit;
    
33. 
    
34. select  * from t07110_a;
    
35. 
    
36. --sys
    
37. alter database set time_zone='+08:00';
    
38. 
    
39. select    owner ,table_name from dba_tab_columns where data_type like '%LOCAL TIME ZONE';
    
40. 
    
41. drop table oe.orders  cascade constraints;
    
42. 
    
43. drop table hr.t07110_a;       
    
44. 
    
45. purge dba_recyclebin;
    
46. 
    
47. drop user APEX_040200 cascade;
    
48. 
    
49. alter database set time_zone='+08:00';
    
50. 
    
51. shutdown immediate
    
52. 
    
53. startup
    

复制代码