Hello, I have an issue casting from float to int. 

usual query works:

> SELECT "value" FROM "xyz" limit 2
name: xyz
--------------------------
time                    value
1391212800000000000     19.1
1391212801000000000     18.8


where this fails:

> SELECT value::integer  FROM "xyz" limit 2
ERR: error parsing query: found :, expected FROM at line 1, char 13

> SELECT "value"::integer FROM "xyz" limit 2
ERR: error parsing query: found :, expected FROM at line 1, char 15


I am following this part of the documentation 
https://docs.influxdata.com/influxdb/v1.0/query_language/data_exploration/#data-types-and-cast-operations-in-queries

What I am missing here?

regards, Michael



-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/97464699-7b4d-45e1-97f1-8a481d6cd7e0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to