Also,
TO_DATE()
should have a secodn parameter I think.
To_Date('01.01.2000', 'DD.MM.YYYY')
Shanx
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.265 / Virus Database: 137 - Release Date: 18-Jul-01