Subject | Re: Date Format in FireBird |
---|---|
Author | ronaldorezende |
Post date | 2003-04-24T19:47:58Z |
Where can I found this in the documentation?
> Formats for date literals in IB/FB are as follows:for
>
> 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
> 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
>
> See you at the First European Firebird Conference in May in Fulda,
> Germany
> http://www.firebird-conference.com
>
> http://www.ibphoenix.com
> For all your upto date Firebird and
> InterBase information