date_format.asciidoc 316 B

1234567891011
  1. [[esql-date_format]]
  2. === `DATE_FORMAT`
  3. Returns a string representation of a date in the provided format. If no format
  4. is specified, the `yyyy-MM-dd'T'HH:mm:ss.SSSZ` format is used.
  5. [source,esql]
  6. ----
  7. FROM employees
  8. | PROJECT first_name, last_name, hire_date
  9. | EVAL hired = DATE_FORMAT(hire_date, "YYYY-MM-dd")
  10. ----