17,088
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE T25
(
MyTime TIMESTAMP
);
INSERT INTO T25 VALUES(to_timestamp('2011-11-29 14:15:22.386', 'YYYY-MM-DD HH24:MI:SS.FF3'));
SELECT * FROM T25;
create table test_u1
(
id char(32),
tt timestamp
)
insert into test_u1
select sys_guid(),to_timestamp('2011-11-29 14:02:29.386','YYYY-MM-DD HH24:MI:SS.FF3') from dual
create table test_u1
(
id char(32),
tt timestamp
)
insert into test_u1
select sys_guid(),to_timestamp('2011-11-29 14:02:29.386','YYYY-MM-DD HH24:MI:SS.FF3') from dual
insert into 表(时间字段) select systimestamp from dual;
select to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') from dual