Tag Archives: day

PrestaShop 101 Day 3 – Categories and Products (1.6)

Prestashop 101 series is a great resource for who wants to learn more about this fantastic e-commerce software. In day three we will have an extensive look at Prestashop categories …

Tags: , , , , , , , , , , , , | Posted under PrestaShop, Video | Leave a comment

Finding Date Closest to Middle or Last Day of Month in SQL

If you have ever worked in SQL or other databases you know that dates can be very tricky. It is not always simple to capture differences and length of time …

Tags: , , , , , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Using PIVOT on Dates in One Column

Suppose you have a table that contains Job ID, when it was started, and when the Job ended. Now you want the difference in days between when it was started …

Tags: , , , , , , , , , , , , , , , | Posted under Programming/Coding | Leave a comment