db2 :
select count(*) from tablename where time > TIMESTAMP('2008-04-01 00:00:00.0') and time < TIMESTAMP('2009-04-30 18:00:00.0')
insert into hr_user values
(1,'admin','admin','admin','gz8851@126.com','15038051203','0','','','','admin',
TIMESTAMP ('2002-10-20-12.00.00.000000') ,'',
TIMESTAMP ('2002-10-20-12.00.00.000000' ) )
oracle:
select * from tableName where timestamp_col >= TO_TIMESTAMP('2007-10-10 00:00:00.0', 'yyyy-mm-dd hh24:mi:ssxff')
(oracle没有测试)
oracle 对IMESTAMP数据类型的操作
insert into hr_user values
(1,'admin','admin','admin','gz8851@126.com','15038051203','0','','','','admin',
TO_TIMESTAMP('2010-05-31 12:00:00.123456789', 'YYYY-MM-DD HH24:MI:SS.FF') ,'',
TO_TIMESTAMP('2010-05-31 12:00:00.123456789', 'YYYY-MM-DD HH24:MI:SS.FF')
)