I think Firebird accepts mm/dd/yyyy, dd.mm.yyyy or yyyy-mm-dd. You cannot
change this, but in general I have no problems whenever I use a parameter
and assign a date to the parameter rather than a string.

HTH,
Set

At 14:28 23.04.2003 +0000, you wrote:

>Probably this had been posted couple of times in this forum, but im
>pretty new to firebird and need some help. Seems like by default the
>db is taking mm-dd-yy as the format for date input. Wondering how
>can I change this to dd-mm-yy format instead. im running on win98,
>tried changing the system short date format, but doesnt help. also
>im accessing the db thro' perl. i've tried $dbh->{ib_dateformat} = %
>d-%m-%y. it helps on the output, but for input it is still expecting
>mm-dd-yy.
>
>btw, im trying to port sql-ledger to firebird, any folks out there
>have already done that and like to share...