I have needed to extract information from a MySQL database on a regular basis and present the information in the form of 'business hours'. One of the biggest issues I have had is that whilst the business days and hours are static and can be filtered (see my article: MySQL limiting selection to business hours) The public holidays themselves change and as such I can't simply remove a specific day.In order to get around this, the easiest way I found was to create another table in MySQL to store the public holidays. In my schema, my table contained holidayID, HolidayName, HolidayState and HolidayDate. This allowed me
I use MySql on a semi-regular basis to analyse data to determine trends and basic statistical information (e.g. min / max / avg) however, one of the issues is often I only care about the information when it occurs within business hours (which in my case is defined as Monday - Friday between 9am and 5pm.Whilst I was aware of WHERE x = y fields, e.g. where sensor = a which lets you only show values in the table where the field sensor = a, I must admit I was not aware of the weekday, hour and between operators.As a result i thought it would
I have been eargly awaiting the release of Aurora HDR 2018 which has been released in the last few weeks. To do a demo, I used a landscape photo I took at the il Tartufo restaurant near Arrowtown, NZ during a work trip. The photo is two stitched images which were stitched in Lightroom and had some very minor editing conducted to the image. The image was duplicated and edited in Aurora HDR 2018 where I picked the "Landscape Enhanced Preset" but made no other changes. Left is old image, right is Aurora HDR.