convert yymmdd to ccyymmdd using ssis
Hi All,
My source date is in yymmdd format.I need it in ccyymmdd format using ssis derived column
Please send me the expression ASAP.
Thanks
RHsql
September 13th, 2012 1:11pm
You need to determine where the borders are... when should there be 20 or 19 ?
Something like:
(DT_I4)(SUBSTRING([yourdatestring],1,2)) < 20 ? "20" + [yourdatestring] : "19" + [yourdatestring]
Is the source string or integer and should the end result be string or integer?Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com |
Twitter
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2012 1:31pm
You need to determine where the borders are... when should there be 20 or 19 ?
Something like:
(DT_I4)(SUBSTRING([yourdatestring],1,2)) < 20 ? "20" + [yourdatestring] : "19" + [yourdatestring]
Is the source string or integer and should the end result be string or integer?Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com |
Twitter
September 13th, 2012 1:38pm
(DT_WSTR, 2) ((DT_I4)(SUBSTRING([<DateColumn>],1,2)) + 1) + <DateColumn>http://btsbee.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2012 2:40pm