John Gedeon wrote: > I tried your sql statement in my oracle db and it said it was missing a > right parenthesis
Oeps, sorry. start and end are reserved words and require double quotes. With them, it works like below: test1=# select version(); version ===================================================================== PostgreSQL 7.2.1 on i386-unknown-openbsd3.1, compiled by GCC 2.95.3 (1 row) test1=# test1=# insert into testtable VALUES (current_timestamp, '2002-01-01'); INSERT 532027 1 test1=# SELECT test1-# CAST( test1(# ( test1(# EXTRACT(DAY FROM ("end" - "start")) || ':' || test1(# EXTRACT(HOUR FROM ("end" - "start")) || ':' || test1(# EXTRACT(MINUTE FROM ("end" - "start")) || ':' || test1(# EXTRACT(SECOND FROM ("end" - "start")) test1(# ) AS VARCHAR) test1-# FROM test1-# testtable; varchar ============================== -269:0:-56:-23.6580430008471 (1 row) Jochem ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists