Category: Programming

February 24, 2018

MySQL: Changing Date Format

I have needed to import a significant amount of information into MySQL from spreadsheets, where a date/time entry is in the format of DD/MM/YYYY...

Continue Reading
February 21, 2018

Remove Public Holidays from MySQL Results

I have needed to extract information from a MySQL database on a regular basis and present the information in the form of ‘business hours’....

Continue Reading
February 12, 2018

MySQL limiting selection to business hours

  I use MySql on a semi-regular basis to analyse data to determine trends and basic statistical information (e.g. min / max / avg)...

Continue Reading
January 26, 2017

Cron Logs (with Timestamps)

Crontabs are an essential function of any linux server, keeping a log is far easier than you would think!

Continue Reading
January 19, 2017

Hostgator & WP-CLI

Using Linux Cron is a great way to keep WordPress in Sync, however cloud-flare can complicate this. On HostGator, WP-CLI is another option!

Continue Reading