Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fahadit2003
Starting Member
1 Post |
 Posted - 2008-02-10 : 08:11:27
|
| I have imported a table from textfile to sql server 2000 using DTS. one of the columns " birth_date" has valuse "??-??-1998" but I want to be displayed e.g "01-08-1998". I have tried "CONVERT" And "CAST" functions but it didn't work. could you please send me the could if it can be done on these functions. if it can't be solved using these functions, is there any other way of doing it Please send me. help always appreciated. thank youshah |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-10 : 08:32:30
|
| Is the source data itself in this form? or is it the import that causes this corruption of data? How is this text file? can you provide some sample data from it? |
 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-02-10 : 15:57:38
|
Is the field imported into a datetime column type? or is the datatype of the column text?You would only format the display of the datetime datatype on the user side or output...not in the source column itself (if it is stored properly as a datetime value)Does the value actually contain the "?" characters? if so...it is a text field and you would have to provide more information.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
date conversion in sql server2000