Will Tomlinson wrote: > I have an evaluation form and trying to work out the best way to add an > elapsed time to the db for the eval. > > In the reporting, I guess I just needta show a MIN(), MAX(), and AVG() on > that field. > But what's the best way to grab the time and insert something my DB functions > can work with.
Just take a start and end time as a full timestamp and substract them. > And what datatype should the field be? INTERVAL is especially designed for this. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290437 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
