Symptom
- 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?
Read more...
Environment
SAP Sybase Adaptive Server Enterprise (ASE) 15.x any release
Product
SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise all versions
Keywords
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.