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 510561260000 value

2

@David_Samm , have a look at the supported datetime functions.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.