create a new date from day , month,year parts

See more:

SQL-Server-2008R2

Dear expert,


Need to compose date in datetime format from the following


Extract the day from GETDATE()

and then join it to the Month Year

so if the GETDATE() is 11/30/2014 which has day 30

and the following will have to be combined with


MONTH YEAR NEW DATETIME COMPOSED
1. 2 2014 02/30/2014 ......
2. 6 2014 06/30/2014 .....


Please provide the necessary to achieve this need

Thanks