informix 的datetime类型year to second 是什么格式?

hawkview

谢谢.

zoukunhong

MM/DD/YYYY HH:MI:SS

hawkview

这句话为什么有错误?

insert into bill_record values("816000555","0254801607","13851519969",
03/27/2002 14:25:34,03/27/2002 14:39:26,7,69
datatype分别为char(20),char(20),char(200,datetime year to second ,datetime year to second ,int,int)

hawkview

可能是因为我加了回车键,怎么处理sql语句中的换行?

zoukunhong

datetime字段加引号.

大梦

datetime year to second
2003-07-09 19:48:50

nsert into bill_record values("816000555","0254801607","13851519969",
"2002-03-27 14:25:34","2002-03-27 14:25:34",7,69
datatype分别为char(20),char(20),char(200,datetime year to second ,datetime year to second ,int,int)