Depends on the database if that funcationality is easily available. [EMAIL PROTECTED] wrote: > > 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)
-- Cheers Glenn Shukster (Logic Fundamentals Inc.) Thornhill, Ont. Canada Phone:(905)771-6458 Fax:(905)771-6819 www.logicfundamentals.com President of TDUG www.tdug.com - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Glenn Shukster <[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)
