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
--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') ); ...
python中将DataFrame数据导入pgsql import psycopg2 from sqlalchemy import create_engine import sqlalchemy account = pd.read_csv('../input/account.csv') dtype_dict = { "together_type" : sqlalchemy.types.VARCHAR , "number" : sqlalchemy.types.INT , "opendate" : sqlalchemy.types.DATE } merge_...
update t_content set title='zxcv',publishtime=to_date('2010-10-01 20:00:00','yyyy-mm-dd hh24:mi:ss') where id=1