c# - Convert date in file from yyyyMMdd to store in SQL as MMddYYYY -

i have file dates in format: 20150530. need format them following format: 05302015 before inserting them sql table. original code was:

private string normalizedate(string strinput)     {         string stroutput;         datetime date;           if (datetime.tryparseexact(strinput, "yyyymmdd", null, system.globalization.datetimestyles.none, out date))         {             stroutput = date.tostring("mmddyyyy");             return stroutput.trim();         }         else         {              return strinput.trim();         }     } 

however, format of date not changing before insert sql. wanted date in format of mmddyyyy (with no dashes or spaces) when insert table. format need merge dates different table format needs mmddyyyy.

the other option have have kind of query can take original date lets table1 (20150530) , convert format table2 in format of (05302015). trying not confuse anyone. data type of table1 datetime , column inserted table2 nvarchar.

if stored datetime

declare @time date ='20100530'  select replace(convert(varchar, @time, 101),'/','') 

if stored int then

declare @time int ='20100530'  select replace(convert(varchar, cast(convert(varchar, @time)as date),101),'/','') 

both change 05302010