Hi,
I am running this through via a SQL command in Crystal reports connecting via ODBC, this is what I have so far, not sure whether the above will work within my select statement.
SELECT
DT."debt-code",
DT."tx-date",
DT."tx-time"
cast(DT."tx-time" as time)
FROM
"PUB"."debt-trans" DT...