Apache Friends Support Forum

How do i set date and time format to British format in xampp. Please help. i have xampp v3.2.2 installed on win10 64bit machine.

Date and time of what?`There is no "make Xampp british" option, which software do you mean (Apache, PHP or MariaDB), which functionality and which API? And what is a british time, what is a british date?

I want MariaDB to pick my system date which british and set to all other projects i am doing that i will be working. Am in the Zambia which was a British colony and is on South Africa/Johannesburg time zone. My excel spreadsheets are set to enter date data in DD/MM/YYYY, which imported into MariaDB. Thx in advance

adamn32 wrote:I want MariaDB to pick my system date which british and set to all other projects i am doing that i will be working.

MariaDB is a SQL Database. You need to program SQL statements for retrieving data. How and where shall MariaDB "pick your system datei and set to all other projects"?? It depends on your SQL and on your PHP scripts, which format is delivered. There is only a "timezone" support for retrieving the system date and adapting it to certain timezones for the "timestamp" value etc., but i dont know if your programs and scripts are using this timestamp.

See https://dev.mysql.com/doc/refman/5.5/en ... pport.html in order to configure your MySQL (MariaDB is a binary replacement).

adamn32 wrote:My excel spreadsheets are set to enter date data in DD/MM/YYYY, which imported into MariaDB. Thx in advance

Then you should change that format into a valid format for MariaDB/MySQL. And add/subtract the amount of hours you need. There is no configuration option to do that automatically. If you do the import via PHP, you can adapt the PHP script to your needs.

Thank you

In your PHP.ini file look for
[Date]
date.timezone=Great Britain/London