British date and Time format.

Problems with the Windows version of XAMPP, questions, comments, and anything related.

British date and Time format.

Postby adamn32 » 27. June 2017 10:57

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.
adamn32
 
Posts: 3
Joined: 27. June 2017 10:39
XAMPP version: v3.2.2
Operating System: Win10 64bit

Re: British date and Time format.

Postby Nobbie » 27. June 2017 13:09

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?
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: British date and Time format.

Postby adamn32 » 28. June 2017 07:34

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
 
Posts: 3
Joined: 27. June 2017 10:39
XAMPP version: v3.2.2
Operating System: Win10 64bit

Re: British date and Time format.

Postby Nobbie » 28. June 2017 09:36

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.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: British date and Time format.

Postby adamn32 » 28. June 2017 11:11

Thank you
adamn32
 
Posts: 3
Joined: 27. June 2017 10:39
XAMPP version: v3.2.2
Operating System: Win10 64bit

Re: British date and Time format.

Postby AppDev » 04. July 2017 04:34

In your PHP.ini file look for
[Date]
date.timezone=Great Britain/London
AppDev
 
Posts: 1
Joined: 04. July 2017 04:22
XAMPP version: 3.2.2
Operating System: Win 10 64Bit


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 117 guests