bbsanwei 发表于 2013-1-30 02:09:08

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);
页: [1]
查看完整版本: informix和oracel对于时间的操作