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

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

David_Samm (David Samm) January 27, 2022, 5:50am 3

Topic		Replies	Views
How to convert timestamp in milliseconds i,e long using elastic-sql Elasticsearch elastic-stack-sql	2	1574	February 24, 2022
Converting TimeStamp to epoch in LogStash Logstash	10	1700	August 28, 2020
Elasticsearch - JSON date payload being converted to type long, cannot use for range queries Elasticsearch	7	2995	March 13, 2018
Is there a way to map a date to milliseconds since epoch for Logstash? Logstash	6	1727	December 30, 2016
Overwrite @timestamp to different format Logstash	2	498	March 9, 2018