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

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

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

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