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) -- 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) - 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)
