Good point. My method would make the data more readable in the database but your method would be more flexible.
-John- At 04:54 PM 12/18/2002 +0100, you wrote: >John Morgan wrote: > > In light of this new information my original suggestion still stands. If > > you format your data as a string (EX: ww:dd:hh:mm) then it will sort > > correctly (assuming you zero pad 3 = 03) and pure string comparison will > > yield correct results. ( "00:03:11:15" GT "00:03:11:25" ) > >But you can't do math on it without resorting to ugly workarounds. One >of the nice parts of a good interval implementation in a DBMS is that >many operations just work automatically. For example, if you want to add >2 intervals, just use interval + interval. Division/multiplication by >numbers, substracting intervals, they all work using the normal >arithmetic operators. > >Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
