• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5281
  • Last Modified:

BCP date format

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
0
lizzzard
Asked:
lizzzard
  • 3
  • 2
1 Solution
 
andrewyuCommented:
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)
0
 
andrewyuCommented:
Anyway, nearly every field type can input as SQLCHAR !

Andrew
0
 
lizzzardAuthor Commented:
OK. I have weekend now. I'll try it at soon as possible. Thanks!
0
 
lizzzardAuthor Commented:
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


0
 
andrewyuCommented:
Havn't you try the MM-DD-YYYY format ?

In Windows NT Server, we can set it in the "Regional Setting" !

Andrew
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now