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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
