Andrew's answer above worked; I adapted it to cater for single digit days:

SELECT TITLE, System_Only, Budget_Date
,IF(LEN(Budget_Date) <=10,
    to_date(CONCAT(0,Budget_Date),'dd MMM yyyy'),
    to_date(Budget_Date,'dd MMM yyyy')
) as FOrmatted