jman76
Hall of Fame
Points: 3388
More actions
November 14, 2013 at 7:04 am
#286238
Hi
I have a file i want to import into a database with the date format as: 20131113
When the date has imported into the table, i would like the format as: 2013-11-13
How can i achieve this in SSIS package.
November 14, 2013 at 7:28 am
#1666371
I actually found the solution to this on Google. Here is the solution:
SUBSTRING([OrderReceived],1,4) + "-" + SUBSTRING([OrderReceived],5,2) + "-" + SUBSTRING([OrderReceieved],7,2)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply