# Select the exact timestamp

**URL:** <https://community.influxdata.com/t/select-the-exact-timestamp/6512>\
**Category:** Systems\
**Tags:** influxdb\
**Created:** [September 7, 2018, 11:13am UTC](https://community.influxdata.com/t/select-the-exact-timestamp/6512 "2018-09-07T11:13:01Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![tofu](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/tofu/32/2111_2.png) [@tofu](https://community.influxdata.com/u/tofu)\
**Post date:** [September 7, 2018, 11:13am UTC](https://community.influxdata.com/t/select-the-exact-timestamp/6512/1 "2018-09-07T11:13:01Z")

</div>

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