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
