You can do a group by on a computed field, therefore you can use the date() function to extract the date from the timestamp field:
select date(mytimestamp) as mytimestamps_date from ... group by mytimestamps_date My syntax may be slightly wrong, I have not implemented this anywhere, but I believe the reasoning to be sound. Terry On Thu, 28 Feb 2002, Dimitri Abramov wrote: > Good point! > > Dimitri > > -----Original Message----- > From: Glenn Shukster [mailto:[EMAIL PROTECTED]] > Sent: February 28, 2002 12:25 PM > To: [EMAIL PROTECTED] > Subject: Re: [CFTALKTor] Storing time as a separate value > > > If you are ever doing a group by query then you can do it by date. With > datetime its not worth doing a group by. > > Dimitri Abramov wrote: > > > > We have a database that stores date and time as separate values in > different > > fields. I am wondering when it could be useful? I used to store datetime > in > > one field as a result of 'now()' function. > > It takes less space (I think) and easer to compare. > > > > Thanks, > > Dimitri > > - > > You are subscribed to the CFUGToronto CFTALK ListSRV. > > This message has been posted by: Dimitri Abramov > <[EMAIL PROTECTED]> > > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > > Manager: Kevin Towes ([EMAIL PROTECTED]) > http://www.CFUGToronto.org/ > > This System has been donated by Infopreneur, Inc. > > (http://www.infopreneur.net) > > -- Terry Fielder Network Engineer Great Gulf Homes / Ashton Woods Homes - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
