How you do that depends on the end result you want.
For example, today is 11 Sept 08. That could be represented in bigint as 20080911, or it could be 39700 (the number of days since 1/1/1900).
(If you simply cast a datetime as float or int or whatever, it is the number of days since 1/1/1900.)
What end-result are you going for? One of these, or something else?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon