- 论坛徽章:
- 0
|
请教给位大神,我这边sybaseiq使用load导入数据,时间格式老是提示转换失败:
SQL Anywhere 错误 -157: 无法将 十一月 9 2014 8:00:00.000000AM 转换为 timestamp (column sttime)
数据库字符集是utf8,导入文件的字符集也是utf8,请问这是什么原因造成的?
set temporary option ESCAPE_CHARACTER='ON';
set temporary option TIMESTAMP_FORMAT ='mmm dd yyyy hh:nn:ss.ssssssaa';
set temporary option DATE_FORMAT ='mmm dd yyyy';
set temporary option DATE_order ='MDY';
truncate table st_s1c_all_60_20141109;
LOAD TABLE st_s1c_all_60_20141109(
sttime '~~~',etime '~~~',hh '~~~',mi '^^^'
)
FROM '/home/sybase/tmp_20141109.csv'
escapes off
quotes off
preview on
Message Log '/home/sybase/msg.log'
Row Log '/home/sybase/row.log'
Only log ALL
format ascii
with checkpoint on;
commit;
数据格式为:
十一月 9 2014 8:00:00.000AM~~~十一月 9 2014 9:00:00.000AM~~~8~~~0^^^ |
|