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



-----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]