SELECT CONVERT(CHAR(12), b.<datefield>1)
FROM TABLE