SQL qury to get specific month columns with null values

To get Specific Month Column
(DATEPART(m, offshore_DD_From)) av to get null values also in that column how to do it....
Input:
21/08/2014 22/08/2014 23/08/2014 NULL 24/08/2014 25/08/2014 Output :
All values should be print incuding NULL and Empty value in the column