SAP Knowledge Base Article - Preview

1901966 - Error 11707 "Incorrect time syntax" while executing LOAD TRAN ..WITH UNTIL_TIME -SAP ASE


  • An error 11701 was raised converting a datetime  string to use in the command  "LOAD TRANSACTION db_name FROM dump_file WITH UNTIL_TIME "08/16/2013 15:31:18":

Server message number=11707 severity=15 state=1 line=1 server=MyServer text=Incorrect time syntax in time string '08/16/2013 15:31:18' used in the LOAD TRANSACTION UNTIL_TIME statement.
Correct format is month day, year hour:minute:seconds:milliseconds[am | pm]

  • In this case, the string "08/16/2013 15:31:18" is being passed into a Perl program where a LOAD TRANSACTION command is set up and executed.
  • How can it be converted to the required format that includes the month name?



SAP Sybase Adaptive Server Enterprise (ASE) 15.x any release


SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise all versions


partial,restore , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.