CastToDouble Spatialite doesn't cast negative numbers

Question

I am using a spatialite database. I need to cast to double a negative number (this number is a text).

When I do SELECT CastToDouble("-5.84"), I get a NULL..

How can i Cast a negative number , in text format, to a Double?

Thanks!

score 1 · Accepted Answer · answered May 28 '14 at 19:16

1

Just use SQLite's built-in cast expression:

SELECT CAST('-5.84' AS REAL)

answered May 28 '14 at 19:16

CL.

1 Answers1