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....
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....