You could add a number of hours to a timestamp using the SQL function dateadd, which works in a very similar way to the CF function of the same name, you would need to add each part of the time variable to the date seperatly.
I'm don't think it's possible to add the whole thing at once. -----Original Message----- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: 02 July 2002 16:17 To: CF-Talk Subject: Adding time I am trying to add a cumulative time variable for a project. I have the SQL var type set a timestamp. I am getting a time variable in an HH:MM:SS format that I want to add to the original time and then submit to the database. I am getting an error saying that allowed conversions between data types is not allowed. Any help would be great. the answer is probably simple but I have been working on this for so long I can not see it. Matt Friedman ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
