Does quest supports milli seconds timestamp during insert an

Question

Does quest supports milli seconds timestamp during insert and select queries in where clause

Andrey Pechkurov · Answer

Hi Ajay Could you clarify what you mean by using milli second timestamp Do you refer to timestamp literals If so yes you can use millisecond precision there ```select from trades where timestamp gt = 2022 03 08T18 03 57 609Z ```

Andrey Pechkurov · Answer

Note that timestamp are stored in microsecond precision so if you insert a `2022 03 08T18 03 57 609Z` timestamp it s stored as if it was `2022 03 08T18 03 57 609000Z`

Ajay Pilaniya · Answer

< Andrey Pechkurov> Is it possible to use epoch timestamps directly

Andrey Pechkurov · Answer

You can do so if you use `cast` `cast my ts value as timestamp `