Column name too wide

[Mel Calvin]

Hi,
If I have a sql query that looks like this:

select user, to_char(updated_date, 'DD-MON-YYYY HH24:MI:SS'), from my_table where id=...

and result is returned as a collection of dynabeans. When I want to retrieve the data from the updated_date column I need to write like this:

(String) dynaBean.get("TO_CHAR(LOGIN_DATE,'DD-MON-YYYY"))

with the "column name" truncated down to 32 chars, else it won't work. Now, this isn't an elegant solution. Anyone have better solution for this?

Thanks.

[Paul Sturrock]

Could you not alias the columns in your result set? i.e.:

select user, to_char(updated_date, 'DD-MON-YYYY HH24:MI:SS') [B]as updated_date [/B] from my_table where id=...

[Mel Calvin]

Aah.. I knew there was a SQL-side solution to this. My SQL skills are limited, thanks for the help!