摘要： 时间函数时间转换函数TO_DATE('201-08-01 00:00:00','%Y-%m-%d %H:%M:%S')示例:INSERT INTO informix.table_name(date1,column_name) VALUES(TO_DATE('201-08-01 00:00:00','%Y-%m-%d %H:%M:%S'),'0')GO时间计算SELECT time1,time1+ INTERVAL(1) HOUR TO HOUR FROM informix.table_name选择时间time1,t 阅读全文

摘要： typeSQL SERVERORACLEINFORMIXDATETIMEDATATIME YEAR TO SECOND 阅读全文

摘要： 1.修改表:添加/删除/修改列ALTER TABLE table_name ADD column_name column_typeALTER TABLE table_name DROP column_nameALTER TABLE table_name modify column_name column_typeinformix 修改列名RENAME COLUMN table_name.column_name TO new_column_name 阅读全文