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.