BCP date format is wrong, not BCP in, help! ! My table format of the date field, "yyyy-mm-dd hh:mm:ss" After the BCP has become a "Jan 24 2005 1:41:07:500PM" of this kind. Bcp in restoring failed, reported the following error Starting copy. . . CSLIB Message :-L0/O0/S0/N24/1/0 : Cs_convert : cslib user api layer : common library error : The conversion/operation was stopped due to a syntax error in the source field. IMPORT PB for failure when I suggested that the date format into wrong! Help me, my data! ! BCP date format is wrong, not BCP in, help! ! In order to create a view, a fixed format store, and then guided out BCP date format is wrong, not BCP in, help! ! Because it is the only backup data! You get help from adults! BCP date format is wrong, not BCP in, help! ! You can build another table, the source database and scripting, guided into, it should not be much problem bars BCP date format is wrong, not BCP in, help! ! Script your bcp (out in) out stickers BCP date format is wrong, not BCP in, help! ! View Field convert to build a corresponding date (nvarchar (30), Field, 112) + '' +convert (nvarchar (30), Field, 108) Can then bcp BCP date format is wrong, not BCP in, help! ! I have such a problem. Bar : em16 who helped advise the exhibitions : Source Database 5.9 OS:SunOS Linux 9.0 database OS:RH Sybase-12.5 database version : Out-- [code] Bcp tableName out tableName.out-c -Uuser -Ppwd -SserverName [/code] In-- [code] Bcp tableName in tableName.out -Uuser -Ppwd -SserverName-c [/code] Derived data sample : Derived ago : --> After derived : --> Wrong message : --> Errfile information : --> BCP date format is wrong, not BCP in, help! ! Try using n? BCP date format is wrong, not BCP in, help! ! T try to increase or BCP date format is wrong, not BCP in, help! ! And the structure of the original agreement marked like this should not happen! If nothing works, varchar built into this series as a good back on BCP date format is wrong, not BCP in, help! ! --> Table structure is the same. The table is built using the same script! Later, had no option but to complete the insertion of the generated SQL. Em10 : : Still like to understand is how the whole thing : em10 : BCP date format is wrong, not BCP in, help! ! And whether there was the transport of data symbols? Add r try, and bcp bcp out in the same ASE server? Or with a version of the ASE? [ Closed window ]