[thelist] SQL: Select first item for each person for each day
Anthony Baratta
anthony at baratta.com
Tue Feb 24 19:11:26 CST 2009
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.
More information about the thelist
mailing list