this is a sort of reposting. I have a datefield in a txt-file I want to bcp-in. (SYB 11.0.2, AIX).
The format of the datefield is dd-mm-yyyy . Up until now I import the datefield as char in a temptable and then select the temptable into my target table using CONVERT in a sp.
What I wanted to know is: Is there a way to tell SYBASE or bcp that the field has to be converted from the dd-mm-yyyy format to a SYB-datetime fiels during te bcp-in