--- In firebird-support@yahoogroups.com, "daniel_lopez_c"
<daniel_lopez_c@y...> wrote:

> I have created a DATE field and I want that the date format be
> dd/mm/yyyy. There are anyway to do it ?

Maybe this can help you

(original post from Pavel Cisar)

Formats for date literals in IB/FB are as follows:

CCYY-MM-DD
MM-DD-CCYY or MM-DD-YY
MMM-DD-CCYY or MMM-DD-YY
DD-MMM-CCYY or DD-MMM-YY
CCYY-MM-DD HH:Min:SS:nnnn
MM-DD-CCYY HH:Min:SS:nnnn or MM-DD-YY HH:Min:SS:nnnn
MMM-DD-CCYY HH:Min:SS:nnnn or MMM-DD-YY HH:Min:SS:nnnn
DD-MMM-CCYY HH:Min:SS:nnnn or DD-MMM-YY HH:Min:SS:nnnn

CC = century
YY = year
MM = month
DD = day
HH = hour
Min = minutes
SS = seconds
nnnn = miliseconds

As segment delimiter you can use hyphen "-", slash "/", dot ".",
stroke
"',", colon ":" or space " ".

IB/FB recognizes both american (MM/DD) and european (DD.MM) notation
for
dates. Notation is recognized by used separator. For european
notation
use dot (excluding pattern with century at the beginning), for
american
notation use all other separators instead dot.

Best regards
Pavel Cisar