Q

Changing date format of a flat file using VB.NET

Development expert Greg Low explains how to use VB.NET to format a flat file into the datetime SQL datatype format.

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.
Using VB.NET, you can use the DateSerial function something like:

outputDate = DateSerial(CType("20" & Left(InputDate,2),Integer),CType(Mid(InputDate,3,2),Integer),CType(Mid(In...

putDate,5,2),Integer))

Assuming all the dates are after 2000. Otherwise, you'll need logic for that too.

This was last published in December 2005

Dig Deeper on .NET Development for SQL Server

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close