try:StrIns := 'insert into tbl_bjdl(bj_yymmdd) values(';
StrIns := StrIns+'to_date('''+CSYear+'-'+CSMonth+'-'+CSDate+' '+CSHour+':'+CSMin+''',''yyyy-mm-dd hh24:mi'')';
StrIns := StrIns+'to_date('''+CSYear+'-'+CSMonth+'-'+CSDate+' '+CSHour+':'+CSMin+''',''yyyy-mm-dd hh24:mi'')';
给个参考:
1.在Oracle服务器中修改注册表的HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE->HOME0中NLS_DATE_FORMAT = YYYY-MM-DD HH24:MI;
2.Oracle下:
create table test (date1 date not null);
3.delphi下:
StrIns :='insert into '+test+' values('+CSYear+CSMonth+CSDate+CSHour+CSMin+')'