date (Function)

Extracts the date part of a date or date-time and return it in yyyy-MM-dd format.

Syntax

<STRING> time:date(<STRING> date.value, <STRING> date.format)
<STRING> time:date(<STRING> date.value)

Query Parameters

Name	Description	Default Value	Possible Data Types	Optional	Dynamic
date.value	The value of the date. For example, 2014-11-11 13:23:44.657, 2014-11-11, 13:23:44.657.		STRING	No	Yes
date.format	The format of the date value provided. For example, yyyy/MM/dd HH:mm:ss.SSS.	yyyy-MM-dd HH:mm:ss.SSS	STRING	Yes	Yes

Example 1

time:date('2014/11/11 13:23:44', 'yyyy/MM/dd HH:mm:ss')

Extracts the date and returns 2022-10-11.

Example 2

time:date('2014-11-23 13:23:44.345')

Extracts the date and returns 2022-10-13.

Example 3

time:date('13:23:44', 'HH:mm:ss')

Extracts the date and returns 1970-01-01.