Select the exact timestamp

influxdb
#1

Hey,

My measurement is as follow:

precision ms
select * from history
name: history
time amount cid exchange exec_ms market price retry side status type


1536317708060 0.0029646324182462966 1536317708060 bitfinex 313 BTC-USD 6372.8 0 buy EXECUTED EXCHANGE LIMIT

This entry is writed with ms precision but when I need to select this exact timestamp (as this is the index) with this command:

select * from history where time = 1536317708060

InfluxDB returns nothing. To select the timestamp it seems that I need to add 0 to match the real entry like this:

select * from history where time = 1536317708060000000
name: history
time amount cid exchange exec_ms market price retry side status type


1536317708060000000 0.0029646324182462966 1536317708060 bitfinex 313 BTC-USD 6372.8 0 buy EXECUTED EXCHANGE LIMIT

Do I need to convert my timestamp 1536317708060 to 1536317708060000000 to select the timestamp or is there a trick I can do ?

influx --version
InfluxDB shell version: 1.5.2