March 21, 2013 at 5:55 am
Just now I have a date column with format of 2011-05-25 I would like to split this into three columns:
Year Month Day
2011 05 25
Can this be done using SSIS ? or even in SQL OLE DB?
March 21, 2013 at 6:37 am
Check out the T-SQL Year(), Month() and Day() functions - you can do this at source.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 21, 2013 at 2:48 pm
dario.quinn (3/21/2013)
Just now I have a date column with format of 2011-05-25 I would like to split this into three columns:Year Month Day
2011 05 25
Can this be done using SSIS ? or even in SQL OLE DB?
TSQL is the easiest option, but if you're feeling adventurous you can also do it in a derived column using similar functions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply