After the misadventure with my nGear eSata EpressCard, I returned it, and I ordered a PPA Int’l eSata ExpressCard. This card uses the JMicron chipset and thus was recognized automatically by my MacBook Pro (OS X v10.5.5). It was not easy to find an ExpressCard with that chipset in Canada. Of course, it would have […]
How to compare dates without taking the time into account
Today, I had to fix a bug in a stored procedure that was not handling dates correctly. A date column was being compared to the current date. However, the current date also contains hour, minute and second values whereas the time part of the date column always contained 00:00:00. In other words, we did not […]