elasticsearch/docs/reference/esql/functions/examples/date_extract.asciidoc

// This is generated by ESQL's AbstractFunctionTestCase. Do no edit it. See ../README.md for how to regenerate it.

*Examples*

[source.merge.styled,esql]
----
include::{esql-specs}/date.csv-spec[tag=dateExtract]
----
[%header.monospaced.styled,format=dsv,separator=|]
|===
include::{esql-specs}/date.csv-spec[tag=dateExtract-result]
|===
Find all events that occurred outside of business hours (before 9 AM or after 5PM), on any given date:
[source.merge.styled,esql]
----
include::{esql-specs}/date.csv-spec[tag=docsDateExtractBusinessHours]
----
[%header.monospaced.styled,format=dsv,separator=|]
|===
include::{esql-specs}/date.csv-spec[tag=docsDateExtractBusinessHours-result]
|===