select '04Apr2011' (date, format 'DDMMMYYYY'), '04/15/2011'

output:
	'04Apr2011'	'04/15/2011'
	04/04/2011	04/15/2011