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 first published in December 2005

Dig deeper on .NET Development for SQL Server

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