DB Connect: Why no Column found on Timestamp?

[Shadolu]

After Running the Query there is no option for Timestamp > Choose Column >  "No result"
Kindly see Image. 

Since I'm going to use the timestamp column well "Timestamp"

currently beginner here 

[tscroggins]

@Shadolu 

DB Connect can't parse the column names out of your SQL. It's a tedious rewrite, but you could try wrapping your CTE with an outer SELECT and explicitly listing the columns:

SELECT
    COLUMN_1,
    COLUMN_2,
    COLUMN_3,
    ...,
    COLUMN_N
FROM (
    WITH ... (
      ...
    )
    SELECT
        ...
    FROM
        ...
    WHERE
        ...
) T