informix和oracel对于时间的操作

bbsanwei

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);