17,377
社区成员
发帖
与我相关
我的任务
分享
create table TEST_XXY
(
id CHAR(32) not null,
name VARCHAR2(15),
submit_time DATE
)
create index IDX_TEST on TEST_XXY (submit_time)
select * from test_xxy t where t.submit_time>to_date('2012-12-01 00:00:00','yyyy-MM-dd hh24:mi:ss')