At 11:57 PM 21/08/2003 +0100, Daniel López wrote:

>And where can I define this format? In the firebird.conf? where?

It's not something you "define". The list quoted are INPUT formats. It
refers to literal formats that Firebird SQL recognises as dates when it
receives values in insert and update statements and expressions.

The output format depends on how your client software handles the number
structures that the database uses to store date/time types. Drivers, e.g.
Jaybird, BDE, IBO...and probably PHP... convert the number into an internal
format that the client language software uses for date types. Then your
application software provides formatting for the output.

For example, Delphi drivers convert Fb/IB date/time types into TDateTime,
an internal numeric format that is different to the db-native formats. By
default, it displays them according to the Windows or Linux locale short
date setting.

If you are writing apps with no driver, then obviously you will have some
work to do to implement it yourself...

heLen

>
>
>-----Mensaje original-----
>De: fabiano_bonin [mailto:fabiano@...]
>Enviado el: jueves, 21 de agosto de 2003 21:23
>Para: firebird-support@yahoogroups.com
>Asunto: [firebird-support] Re: Date Format on Firebird 1.5 RC5
>
>
>
>--- 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
>
>
>
>
>
>
>
>Yahoo! Groups Sponsor
>
>
>
>ADVERTISEMENT
>
><http://rd.yahoo.com/M=261419.3724993.5015550.1269402/D=egroupweb/S=17051153
>86:HM/A=1724960/R=0/SIG=136t8cgia/*http:/ads.x10.com/?type=href&lineid=37249
>93&property=egroupweb&aposition=HM&random=1061497403160319>
>
>
>
><http://us.adserver.yahoo.com/l?M=261419.3724993.5015550.1269402/D=egroupmai
>l/S=:HM/A=1724960/rand=129854064>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the Yahoo!
><http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/