apoc.date.convertFormat
Function
apoc.date.convertFormat(temporal STRING, currentFormat STRING, convertTo STRING)
- converts a STRING
of one type of date format into a STRING
of another type of date format.
Signature
apoc.date.convertFormat(temporal :: STRING, currentFormat :: STRING, convertTo = yyyy-MM-dd :: STRING) :: STRING
Input parameters
Name | Type | Default |
---|---|---|
temporal |
STRING |
null |
currentFormat |
STRING |
null |
convertTo |
STRING |
yyyy-MM-dd |
Usage Examples
The The |
The following converts a date in YYYY-MM-dd
format to basic_date
(yyyyMMdd
) format:
RETURN apoc.date.convertFormat("2020-11-04", "date", "basic_date") AS output;
output |
---|
"20201104" |
The following converts a date in date_hour
(yyyy-MM-dd’T’HH
) format to date_hour_minute
(yyyy-MM-dd’T’HH:mm
) format:
RETURN apoc.date.convertFormat("2020-11-04T22", "date_hour", "date_hour_minute") AS output;
output |
---|
"2020-11-04T22:00" |