Solved

BCP date format

Posted on 1999-01-20
5
4,788 Views
Last Modified: 2010-10-05
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
Comment
Question by:lizzzard
  • 3
  • 2
5 Comments
 

Expert Comment

by:andrewyu
ID: 1098562
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
 

Expert Comment

by:andrewyu
ID: 1098563
Anyway, nearly every field type can input as SQLCHAR !

Andrew
0
 

Author Comment

by:lizzzard
ID: 1098564
OK. I have weekend now. I'll try it at soon as possible. Thanks!
0
 

Author Comment

by:lizzzard
ID: 1098565
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
 

Accepted Solution

by:
andrewyu earned 100 total points
ID: 1098566
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
truncation error - math operation 6 561
SQL Left join on same table 4 301
SQL Query Syntax 17 158
Converting some Sql server syntax to Sybase Syntax. 8 38
Scenario: Your operations manager has discovered an anomaly in your security system. The business will start to suffer within 15 minutes if it is a major IT incident. What should she do? We have 6 recommendations for managing major incidents (https:…
We need a new way to communicate time sensitive or critical info.   The best part of my role at xMatters is visiting our clients all over the world to learn about how they operate their businesses, share insights that xMatters has gleaned across…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now