Nevermind ... just did this: SELECT end_time from items group by end_time HAVING DATEDIFF( minute, '2/24/2003 12:30', END_TIME) >= 0
H. > -----Original Message----- > From: Owens, Howard [SMTP:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 12:16 PM > To: SQL > Subject: DATEDIFF query > > I'm tried doing something like this: > > SELECT DATEDIFF( minute, '2/24/2003', END_TIME) as MINUTESLEFT > from items > WHERE MINUTESLEFT > '2/24/2003 12:30' > > but apparently I can't compare the alias as a column name ... how might I > do > something like this ... can you see what I'm trying to get at ... I want > to > find all of the items with an end time prior to today's date. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Howard Owens > Internet Operations Coordinator > InsideVC.com/Ventura County Star > [EMAIL PROTECTED] > AIM: GoCatGo1956 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
