<div>
You can use it and declare the field in the format file as SQLCHAR !<br />
<br />
By the way, you can try this by &quot;bcp out&quot; copy the table into file, assign the date field to SQLCHAR and output the format file !<br />
<br />
Andrew<br />
(I did it in MS-SQL 6.5)<br />

</div>


You can use it and declare the field in the format file as SQLCHAR !

By the way, you can try this by "bcp out" copy the table into file, assign the date field to SQLCHAR and output the format file !

Andrew
(I did it in MS-SQL 6.5)


<div>
Anyway, nearly every field type can input as SQLCHAR !<br />
<br />
Andrew<br />

</div>


Anyway, nearly every field type can input as SQLCHAR !

Andrew


<div>
OK. I have weekend now. I'll try it at soon as possible. Thanks!<br />

</div>


OK. I have weekend now. I'll try it at soon as possible. Thanks!


<div>
Hi,<br />
<br />
SYBASE doesn't has a SQLCHAR format. It has a SYBCHAR, which is what you mean I think. However, it doesn't like DD-MM-YYYY formats. It only seems to accept a 26 character format like, december 26 1998 12:00:00 AM<br />
<br />
<br />

</div>


Hi,

SYBASE doesn't has a SQLCHAR format. It has a SYBCHAR, which is what you mean I think. However, it doesn't like DD-MM-YYYY formats. It only seems to accept a 26 character format like, december 26 1998 12:00:00 AM




<div>
<div class="content wysiwyg-content">
Hi,<br />
this is a sort of reposting. I have a datefield in a txt-file I want to bcp-in. (SYB 11.0.2, AIX).<br />
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.<br />
<br />
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<br />
<br />
Thanks, Alex
</div>
</div>


Hi,
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

Thanks, Alex

BCP date format

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.