Daily Archives: October 7, 2006

Nova Scotia: Open 7 days a week.

Posted on October 7, 2006 by Arthur

The biggest news event this week (you heard this on CNN first! Wait, no, scrap that) now prominently featuring on today’s Tourism NS e-postcard, which you can send to your Europeans pals (who obviously don’t enjoy this particular human right … Continue reading →

Posted in Tourism Canada | Comments Off on Nova Scotia: Open 7 days a week.

You asked: How to find count between two dates mssql

Posted on October 7, 2006 by Arthur

Oh: that age old problem. It depends on what you’re looking for? Years, days? Milliseconds? /* Days */ select DATEDIFF(D, getdate(), ’10/11/06′); select DATEDIFF(Y, getdate(), ’10/01/02′); You may need to be careful with using year calculations: obviously MS SQL does … Continue reading →

Posted in SQL, You-Asked | 2 Comments