db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Kellerer <spam_ea...@gmx.net>
Subject Problem with cast
Date Tue, 04 Mar 2008 21:41:38 GMT

I am having trouble running a SELECT statement with the CAST operator, and I 
cannot understand where the problem is:

I have a table with an integer column (id).

When I run the following statement:

SELECT cast(id AS VARCHAR) FROM mytable;

I get an error:

ERROR 42X01: Syntax error: Encountered ")" at line 1, column 26.

I cannot see an error in my SQL statement, so what am I missing here?

I'm using Derby (599110)


View raw message