Oracle插入时间数据
Shell log below:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
SQL> show user USER is "SYS" SQL> SQL> create table server_list 2 ( 3 server_no number, 4 server_name varchar2(30), 5 created_time date 6 ); Table created. SQL> desc server_list; Name Null? Type ----------------------------------------- -------- ---------------------------- SERVER_NO NUMBER SERVER_NAME VARCHAR2(30) CREATED_TIME DATE SQL> SQL> insert into server_list values (1,'aliceme',to_date('2014-11-15 14:31:10','yyyy-mm-dd hh24:mi:ss')); 1 row created. SQL> select * from server_list; SERVER_NO SERVER_NAME CREATED_T ---------- ------------------------------ --------- 1 aliceme 15-NOV-14 SQL> select server_no,server_name,to_char(created_time,'yyyy-mm-dd hh24:mi:ss') "Created Time" from server_list; SERVER_NO SERVER_NAME Created Time ---------- ------------------------------ ------------------- 1 aliceme 2014-11-15 14:31:10 SQL> |
——————————————————————-
Ending。