thanks for all your help guys, i got it sorted, Lisa
-----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 16:18 To: CF-Talk Subject: Re: CreateDateTime function?? John Morgan wrote: > Good point. My method would make the data more readable in the database but > your method would be more flexible. More readable? The copy-pasted example below uses some non-standard extensions like week and century, but you will get the point: test=# create table ivtest (test interval); test=# insert into ivtest values ('1 week 3 days 2 hours 45 seconds'); test=# insert into ivtest values ('1 century 2 years 4 months 42 week 3 days 17 hours 33 seconds'); test=# select * from ivtest; test ------------------------------------ 10 days 02:00:45 102 years 4 mons 297 days 17:00:33 test=# select sum(test) from ivtest; sum ------------------------------------ 102 years 4 mons 307 days 19:01:18 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
