TO_CHAR (due_date,'MM-DD-YYYY') This is a correct to convert date to character.
Márcio de Souza Almeida DBA Oracle / SQLServer / PostgreSQL Rua Cupa, 139 Apto 85 A Penha - São Paulo - SP 03640-000 - Brasil http://www.directory.com.br
Forum Rules