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 ONE Support launchpad (Login required).

Search for additional results

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