Best Geek Quotes

#1. Roses are #FF0000, Violets are #0000FF. All my base Are belong to you  — someone on SlashDot #2. There is no place like 127.0.0.1 #3. Girls are like Internet Domain names, the ones I like are already taken #4. Programming today is a race between software engineers striving to build bigger and better idiot-proof… Read More »

The 5 types of programmers

In my code journeys and programming adventures I’ve encountered many strange foes, and even stranger allies. I’ve identified at least five different kinds of code warriors, some make for wonderful comrades in arms, while others seem to foil my every plan. However they all have their place in the pantheon of software development. Without a… Read More »

Time as Decimal, Date as string, Combine to DateTime.

DECLARE @f [real] DECLARE @CurDate [Date] SET @f = 13.5323653232 SET @CurDate  = ‘20140911’ SELECT DATEADD(mi, (@f – FLOOR(@f)) * 100, DATEADD(hh, FLOOR(@f), CAST (’00:00:00′ AS TIME))) SELECT Cast(CONVERT(DATETIME, CONVERT(CHAR(8), @CurDate, 112)   + ‘ ‘ + CONVERT(CHAR(8), DATEADD(mi, (@f – FLOOR(@f)) * 100, DATEADD(hh, FLOOR(@f), CAST (’00:00:00′ AS TIME))), 108)) as DATETIME) SELECT datediff(dd,Cast(CONVERT(DATETIME, CONVERT(CHAR(8),… Read More »