Hi,

>I am using Firebird 2.1 under linux platform. It can be extract a date
>into DDD-MM-YYYY format ? eg(Mon-12-2008).

Your client can format the date any way you want.

If you're talking about stored procs / triggers then CAST a date as varchar
will *always* result on a string formated as 'yyyy-mm-dd'. So, you need to
do some code yourself (using extract, substr, etc) to format the way you
want or use an UDF for that -- FB has no build-in function to format dates
(to string).


Regards,
Anderson Farias