Apache :: Apache 2.2.22 & PHP 5.3.8

HelderS · Joined: 11 Sep 2012 Posts: 2 Location: Portugal

Hello, everyone,

I'm experiencing some problems after I installed Apache 2.2.23 and PHP 5.3.8 on a Windows Server 2008 R2.

I've both Apache and PHP working. But when I started to use my web application that uses Dates, which were working ok on a different computer, but accessing same database computer( portuguese date/time definitions).

The problem is: I've defined in "Region and Language" settings of Windows to Portuguese format( day-month-yyyyear Hour:Minute:Seconds ), and when I retrieve a Date/Time variable from a SQL Database it returns in a format that appears to be American ( month/day/yyyyear Hour:Minutes:Seconds AM/PM )

Is it possible to define the portuguese format anywhere in Apache?

I've already changed the setting for timezone in php.ini, but It seems to remain the same.

Hope someone could help me.

Thanks in advance.

Best regards,

Hélder Silva

James Blond

You can sue pure PHP to do so.

HelderS · Joined: 11 Sep 2012 Posts: 2 Location: Portugal

Yes, but like I said, it was actually working before this new setup, and I'm avoiding change the PHP code.

Thanks anyway, but not the solution I was looking for.

Hélder

James Blond

You can set it on MySQL as well

See
http://dev.mysql.com/doc/refman/5.5/en/locale-support.html

See also http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html
SELECT DATE_FORMAT('2007-10-04 22:23:00', '%H:%i:%s');