SQL Date functions
Posted on Apr 27th, 2009I always forget this so its here forever!
This is how to get the current Date..
CONVERT(varchar(8), GETDATE(), 112)
This is how to get the date from a datetime field
CONVERT(varchar(8), *InsertFieldHere*, 112))
Select queery to get the recoreds from a dateTime field for today..
SELECT *
FROM *Table*
WHERE (CONVERT(varchar(8), GETDATE(), 112) == CONVERT(varchar(8), *InsertFieldHere*, 112)) ORDER BY Datetime
Bacon sandwich really does cure a hangover
Posted on Apr 26th, 2009British researchers found that eating concentrated doses of carbohydrates and protein after some “over indulgence” can speed up your metabolism and provide the amino acids needed to start feeling better. BLT for breakfast, anyone?
Any amateur college biologist will suggest “heavy” or “greasy” food the morning after a long night out, as it “soaks up” the remaining alcohol in your system—or something like that, it’s hard to remember. Newcastle University researchers suggest that age-old remedy is rooted in how the protein provided by bacon and other meats is broken down into amino acids, which in turn replenish the nerotransmitters depleted by a long night of drinking.
Source : The Telegraph
Starting Eve Online
Posted on Apr 26th, 2009
I have been playing WoW alot since wotlk came out ( 2 chars to 80 now, 1 to go) and decided it was time for a bit of a break to refresh my WoW batteries (Not great timing as 3.1 just came out). Ori mentioned that he was interested in playing Eve online. I have to admit i knew very little about eve, I watched the Zero punctuation video and Yahtzee gave it a good slagging off but thats about all I knew. I was aware that eve had just released a mac client so its one of the few games a I could actually try (It was a bit of a git missing lotr and warhammer online).
So i headed to the eve online website downloaded it and signed up for the 15 day free trial. First thing i have to say is the game is bloody complicated! I decided to create a mining / industrial char. I have never been the type of person to jump in feet first to the pvp i enjoy the supporting roles. I followed the first questline and got confused even more… All i knew was I had just completed a mission and had been given a badger. In my mind this is the best way to get me hooked on a game…
At the moment I am concentrating on the mining, It seems to be going pretty. I am concentrating on the Veldspar mining is some 0.7 areas. I read a mining guid that had a tip on using waypoints to help speed up the process. Basically you warp to a asteroid then travel 10km past them (with the space station behind you). Once you are here set your waypoint. This way when you warp back to the belt warp to the waypoint this way you will warp into the middle of the asteroid’s rather than 10km away.
