This content has been marked as final. Show 2 replies
You could use the to_date function and specify the date format, for example:
insert into "dateime1"@dg4msql_emgtw_1123_db values (1,to_date('2012-06-25 07:39:45','yyyy-mm-dd hh:mi:ss'));
Just as with Oracle, you have to specify the date using the to_date() function or use the native date format for the target database (if you can figure out what that is). This is good practice anyway and a good habit to get into.