[thelist] SQL: Select first item for each person for each day

Ken Schaefer Ken at adOpenStatic.com
Tue Feb 24 21:22:25 CST 2009

SQL Server 2000 stores datetime fields as two numbers - one for days since 1/1/1900 and one for the number of milliseconds since midnight. Casting to int seems to drop the time part...


-----Original Message-----
From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Anthony Baratta
Sent: Wednesday, 25 February 2009 12:11 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] SQL: Select first item for each person for each day

Ken Schaefer wrote:
> 	CAST(b.Appointment_Date AS Int) = CAST(GetDate() AS Int)

That's an interesting shortcut!

I would think that is time fluxing too, but testing shows me otherwise. 
Looks like that is the number of days since 01-01-1900.

Guess we only have to worry about SQL integer overflow in 5.8 million 
years. But the SQL Date field will over flow by year 10,000 anyway, so 
it's a moot point. :-)

Thanks for the info.

Anthony Baratta

Gollum: verb
To obsessively and compulsively covet without the ability to enjoy that 
which you covet.


* * Please support the community that supports you.  * *

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 

More information about the thelist mailing list