topic Re: Insert timestamp into external MS SQL table using ABAP in Application Development and Automation Discussions

Insert timestamp into external MS SQL table using ABAP

former_member239066 — Fri, 28 Oct 2016 10:51:03 GMT

Hi Expert,

We have a requirement for which we have to insert records in an MS SQL table. The table contains a field of type DATETIME. We need to fill that field with the actual date and time.

We have concatenated date and time in the format 'YYYY-MM-DD HH:MM:SS' and we are getting the dump 'SQL error 241 occurred while executing Native SQL.'.

We are looping on an internal table to insert each record 1 by 1.

Could you please help to find a solution for the timestamp?

Thanks,

Vitish.

Re: Insert timestamp into external MS SQL table using ABAP

Jelena_Perfiljeva — Fri, 28 Oct 2016 13:18:47 GMT

What have you tried so far? Google -> "SQL error 241" finds 400K+ entries, surely some of the posts should have triggered some ideas and further analysis. Ask the external database's DBA as well. It's not really an ABAP question.

Re: Insert timestamp into external MS SQL table using ABAP

former_member239066 — Thu, 12 Jan 2017 08:13:49 GMT

Hello Jelena,

The issue is solved. The timestamp format should be 'YYYY-DD-MM HH:MM:SS' instead of 'YYYY-MM-DD HH:MM:SS'.

Regards,

Re: Insert timestamp into external MS SQL table using ABAP

Jelena_Perfiljeva — Thu, 12 Jan 2017 19:56:26 GMT

If this is resolved then kindly let others know by accepting an answer. Otherwise this still shows up as "unanswered". Thank you.