Subject Re: [firebird-support] Date Format on Firebird 1.5 RC5
Author Marco Lauria
At 16:27 21/08/2003 +0000, you wrote:
>I have created a DATE field and I want that the date format be
>dd/mm/yyyy. There are anyway to do it ?

No, with Firebird you can't change the date format.
It accepts a defined number of date formats.
If you need dd/mm/yyyy you can use the EXTRACT function.
You can extract year,month and day and you can create a computed field DAY
|| '/' || MONTH || '/' || YEAR.
Regards
Marco