Q

Can I change the date format when moving a flat file to SQL?

I am trying to copy a flat file into a table in SQL using DTS, but the flat file has been generated by an AS/400 system and the date is formatted like this (yymmdd=051206). At the time of conversion I want it to be formatted into the datetime SQL datatype format. I am developing in VB.NET. Thank you for you assistance on this.
I would recommend reviewing the CAST and CONVERT syntax in order to properly format the date.
This was first published in December 2005

Dig deeper on Microsoft SQL Server Performance Monitoring and Tuning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close