Category: MySQL

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