Subject Re: How to format date using Firebird field
Author Reinhard Neidl
--- In firebird-php@yahoogroups.com, "rc.199011" <rc.1990@...> wrote:
>
> I am using Windows Vista Premium and Ubuntu 9.4, Apache 2, PHP 5.2.9 and Firebird 2.1.
>
> When I make a select against Firebird, the date filed is showm as "m/d/Y H:M:S", but I need show li "d/m/Y H:M".
>
> I have tried change PHP.ini and use init_set(ibase.dateformat, "%d-%m-%Y"), but they did not work.
>
> Is there a function similar to "number_format($row->MONEY_VALUE, 2, ',', '.')" to format date and time?
>
> Thanks,
>
> Roberto Carlos
>
--- In firebird-php@yahoogroups.com, "rc.199011" <rc.1990@...> wrote:
>
> I am using Windows Vista Premium and Ubuntu 9.4, Apache 2, PHP 5.2.9 and Firebird 2.1.
>
> When I make a select against Firebird, the date filed is showm as "m/d/Y H:M:S", but I need show li "d/m/Y H:M".
>
> I have tried change PHP.ini and use init_set(ibase.dateformat, "%d-%m-%Y"), but they did not work.
>
> Is there a function similar to "number_format($row->MONEY_VALUE, 2, ',', '.')" to format date and time?
>
> Thanks,
>
> Roberto Carlos
>

check out
<?php
echo date('OutputFormat', mktime(.$FB-DateString.));
?>

http://de.php.net/manual/de/function.mktime.php
http://de.php.net/manual/de/function.date.php