Subject | Date Format in FireBird |
---|---|
Author | desmondtay88 |
Post date | 2003-04-23T14:28:57Z |
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...
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...