How to convert timestamp in milliseconds i,e long using elastic-sql

Elastic Stack Elasticsearch
1 
Hi,

I have timestamp fields where I want to convert this timestamp to long i,e milliseconds

GET    /_sql
{

  "query":"select  "2017-11-13T13:51:00.000Z" as date from employee "

}
    here I want the timestamp  "2017-11-13T13:51:00.000Z" to  some 510561260000 value
2

Can you please reformat your post so it's readable. You don't need to have the entire thing as a quote block :slight_smile:

3

hi @warkolm ,

I am unable to edit my previous post so I have created a new one
[How to convert timestamp in milliseconds i,e long using elastic-sql](https://New One)