On 9-11-2018 13:38, info@... [firebird-support] wrote:

> I use Firebird primarily with Delphi and have had no problems with using
> and displaying dates (suitable for my country - UK.)
>
> However, it seems to be a big problem with Firebird and dates when
> working with PhP with  firebird driver. I have a number of fields that
> hold information in a field defined to be of type  "date" in Firebird.
> When I use PhP to query my database I get the fields formatted in the
> ISO-8601 format (year/month/day.. etc).

Disclaimer: I don't use PHP, but a quick google suggested
https://secure.php.net/manual/bg/function.ibase-timefmt.php; that seems
to be a function that has been removed, but one of the comments suggested:

```
/**
* Constant definitions that has been removed from PHP 5
*/
const IBASE_DATE = "ibase.dateformat";
const IBASE_TIME = "ibase.timeformat";
const IBASE_TIMESTAMP = "ibase.timestampformat";

/**
* Sets the format of timestamp, date or time type
* columns returned from queries
*/
function ibase_timefmt($format, $where = IBASE_TIMESTAMP)
{
ini_set($where, $format);
}
```

And https://secure.php.net/manual/en/ibase.installation.php (see first
comment) suggests this can also be configured in the php.ini file.

Mark
--
Mark Rotteveel