--SQL语句往Oracle数据库中插入日期型数据(to_date的用法) INSERT INTO FLOOR VALUES ( to_date ('2007-12-20 18:31:34','YYYY-MM-DD HH24:MI:SS') ) ; --查询显示:2007-12-20 18:31:34.0 --- INSERT INTO FLOOR VALUES ( to_date ('2007-12-14 14:10','YYYY-MM-DD HH24:MI') ); ...
oracle吗？你在java中把日期转换成yyyy-mm-ddhh:mm:ss的格式后再处理：比如：updatet_contentsettitle='zxcv',publishtime=to_date('2010-10-0120:00:00','yyyy-mm-ddhh24:mi:ss')whereid=1
比如：update t_content set title='zxcv',publishtime=to_date('2010-10-01 20:00:00','yyyy-mm-dd hh24:mi:ss') where id=1