I wish to extract from a field and tried a query similar to mysql:
select left(syslog_timestamp,10) from test_metric limit 1;
However, I had:
ERR: undefined function left()
Please help and sorry if my question is too newbie.
Thanks a lot in advance
I’m pretty sure InfluxDB doesn’t support any text functions like MySQL does. You’ll need to extract the full value and do the substring/left/whatever outside of the query / in your other code.
Please see list of query functions available in InfluxDB.
Thanks a lot. shall try as advised