Extra from a string

Telegraf
1

Hi All,

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

2

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.

3

Thanks a lot. shall try as advised