. . . #desired format: day.month.year Hour:Minutes:Seconds $dbh->{ib_timestampformat} = '%d.%m.%Y %H:%M:%S'; $sth = $dbh->prepare($query); . . .