in reply to Re: DBD-InterBase: different date/time formats
in thread DBD-InterBase: different date/time formats

Hi everybody,

with your help (thanks to paulbort, pgor, digger) I "figure it" out - found the solution, like previously mentioned monks said/posted to my question!

So, I noticed that my so called problem was because of "undefined" date/time format of the DBD-InterBase driver, but after changing (or should I say adding) this before the prepare method, solved the problem:

. . . #desired format: day.month.year Hour:Minutes:Seconds $dbh->{ib_timestampformat} = '%d.%m.%Y %H:%M:%S'; $sth = $dbh->prepare($query); . . .
or even (what is the same!):
. . . $attr = { ib_timestampformat => '%d.%m.%Y %H:%M:%S' }; $sth = $dbh->prepare($query, $attr); . . .

Thanx again to all of you!

Regards, Pet.