informix和oracel对于时间的操作

update TS_GroupCustAttr set applydeletetime
= TO_DATE("2008-07-22 00:00:00","%Y-%m-%d %H:%M:%S")
where groupcustomerkey = 2000000152;

insert into userdb17.OCS_SubNegBalance
 values(915, to_date('2008-2-9 10:30:38', 'yyyy-mm-dd hh:mi:ss'), to_date('2008-2-9 10:30:38', 'yyyy-mm-dd hh:mi:ss'), 1, -100, 0);