derived column query

Question

how to extract month and year part together from date in derived column.

Ex-date-2010-12-21

Desired result-201012 (i.e-concatenation of year and month)

Reply as soon as possible

Thanks in advance

Sunny Prakash

Answer 1

Use (DT_WSTR,4)YEAR(<DateTime Column>) + (DT_WSTR,2)MONTH((<DateTime Column>) )

---

http://btsbee.wordpress.com/

Answer 2

Better still use this

(DT_WSTR,4)YEAR(<DateTime Column>) + REPLICATE("0",2 - LEN((DT_WSTR,2)MONTH(<DateTime Column>))) + (DT_WSTR,2)MONTH((<DateTime Column>))

as the above will pad single digit months with leading zeroes.

---

http://btsbee.wordpress.com/

Answer 3

how to extract month and year part together from date in derived column.

Ex-date-2010-12-21

Desired result-201012 (i.e-concatenation of year and month)

Reply as soon as possible

Thanks in advance

Sunny Prakash

Or use

SUBSTRING(REPLACE((DT_WSTR, 20)DateColumn,"-",""),1,6)

which is shorter

---

Arthur My Blog