The transition into a new year is a difficult one for a programmer. When the year ends, dates don’t continue on, they restart. It’s like driving on a race track, but the track doesn’t loop. So when you complete a lap, you have to drive all the way back to the beginning (moving from month 12 to month 1). This can be a big issue for developers, especially when we have to take into account Leap Years and even Leap Seconds. With more programming languages including Date&Time classes it is sometimes easier, but there are still issues.
Over the past month or so, I’ve been working on developing a series of iPhone web-apps for work. When I was asked to write these web-apps, my first thought was to write in PHP for the template flexibility. However, since our campus uses all Microsoft products, our web servers are IIS and our SQL servers are Microsoft SQL 2005. This forces us developers to stick with Asp.NET, even if the situation doesn’t call for it. Continue Reading »