Using the interval data type

[bluedart]

I'm using a query that returns a value as an 'interval' data type. When I run
that query through CF only an [empty string] is returned. I've tried casting
the value as an integer, but that threw an error.

Any ideas as to how I can use a value with the data type of interval in CF?

Thanks.

[mxstu]

What database are you using? Did you check your driver documentation to
determine whether it supports the "interval" data type? You might also want to
try casting the value as a varchar, just for grins.

[bluedart]

I'm using Postgres 7.4. but have changed my thinking and fixed the problem.
Rather than have the database process the age of the record, I'm doing the
processing in ColdFusion. From what I can tell it is working fairly accurately.

Thank you for responding!