It just doesn't returns the time properly from the database.
First, everything was working fine before running the application in
the new server.
After we got it running it the new server it records the data
properpely (I'm using EMS as a database managment software). But when
I retrieve the data it shows always the wrong value, acctually it
shows always the same value: 17:39.
Like... I recorded in the database 08:00:00... When php retrieves that
value it gives me 17:39. Another thing that I noticed it is that EMS
it is showing me the TIME information in the AM/PM format instead of
the 24h format. Like... instead of showing me 23:00:00 it is showing
11:00:00 PM. So... I guess the problem it is somewhere between the
server configuration and php configuration.


The LOCALE configuration in the server is as follows:

LANG=pt_BR
LANGUAGE=pt_BR:pt:en
LC_CTYPE="pt_BR"
LC_NUMERIC="pt_BR"
LC_TIME="pt_BR"
LC_COLLATE="pt_BR"
LC_MONETARY="pt_BR"
LC_MESSAGES="pt_BR"
LC_PAPER="pt_BR"
LC_NAME="pt_BR"
LC_ADDRESS="pt_BR"
LC_TELEPHONE="pt_BR"
LC_MEASUREMENT="pt_BR"
LC_IDENTIFICATION="pt_BR"
LC_ALL=

In the php.ini I couldn`t find ibase directives... I read somewhere
that it could be the ibase.timeformat directive. The Systems
administrator added the line

ibase.timeformat = "%H:%M:%S"

in the Dynamic Extensions session of the php.ini file.

I'm starting in web programming and any help will be much welcome!

Thank you all!!!
Lu

--- In firebird-php@yahoogroups.com, Lester Caine <lsces@...> wrote:
>
> luluzynha13 wrote:
> > Besides the php.ini configuration and the LOCALE settings of the
> > server what else can affect the time data? I've been having problems
> > with retrieving TIME data from my database and displaying it correctly
> > in my php apllication.
> >
> > The Upgrading information is:
> > Old Version - New version
> > php 4.* - php 5.2.*
> > firebird 1.5.2.* - firebird2 1.5.3.48*
> >
> > Besides PHP.ini directives and LOCALE settings on the server there is
> > anything else I should look for? Plus... Is there a way to make the
> > time completelly independent from php?
>
> Just time? or time and date?
> There have been a few comments about the time ZONE being wrong in
5.2.x but I
> think that has been finger trouble with the new timezone database.
> So as Alan says - what is the problem?
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
> L.S.Caine Electronic Services - http://home.lsces.co.uk
> MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
> Firebird - http://www.firebirdsql.org/index.php
>