Q
Problem solve Get help with specific problems with your technologies, process and projects.

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(InputDate,5,2),Integer))

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

Dig Deeper on .NET Development for SQL Server

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close