[8.17] [ES|QL] Update the functions definitions and tests to include date_nanos (#201078)

[kibanamachine]

Backport

This will backport the following commits from main to 8.17:

• [ES|QL] Update the functions definitions and tests to include date_nanos (#201078)

Questions ?

Please refer to the Backport tool documentation

[elasticmachine]

:yellow_heart: Build succeeded, but was flaky

• Buildkite Build
• Commit: 0a9fa39cbc70d11725eca8d36332100719f31d4a

Failed CI Steps

• FTR Configs #1

Test Failures

• [job] [logs] FTR Configs #1 / Controls Dashboard control group apply button range slider selections making selection enables apply button

Metrics [docs]

Async chunks

Total size of all lazy-loaded chunks that will be downloaded as the user navigates the app

id	before	after	diff
securitySolution	13.4MB	13.4MB	+2.8KB

Page load bundle

Size of the bundles that are downloaded on every page load. Target size is below 100kb

id	before	after	diff
kbnUiSharedDeps-srcJs	3.4MB	3.4MB	+2.8KB

cc @stratoula