convert column into datetime format

[santoshpayal]

Hi,

I have a text file that contains a date column. The text file will be
imported to database in SQL 2000 server. After to be importing, I want
to convert the date column to date type.

For ex. the text file look like

Name date
Smith 06092006 023718

It would be converted date column to ydm database in SQL 2000 server.
In the table it should look like this

Name Date
Smith 2006-09-06 hh:mm:ss.mmm

i used the query

select convert(varchar(15), getdate(), 25) from table name

which gives me the current date in the desired format...how can i replace the current date parameter to include the column 'Date'???


Much thanks in advance
appreciate if someone can help on this....