where full_date = to_date('11/30/2004','DD/MM/YYYY')
It aint a typo if you live in the UK