Extract Date Part

Description

Extracts date parts (Year, Month, Day,..) as integers and strings

Input

• SOURCE [OBJ]: a list of objects

Output

• PAIR [OBJ,INTEGER]: for each object in the input source the extracted integer value is provided as the second column in [OBJ,INTEGER]. When multiple values can be extracted for an object, each object-value pair is returned as a separate result.

• RESULT [INTEGER]: the extracted values, disjoint from their parent object. Use the score aggregation parameter to define how occurrences of the same values are handled.

• SPAIR [OBJ,STRING]: same as PAIR, but with values as strings

• SRESULT [STRING]: same as RESULT, but with values as strings

Parameters

• Property: the property to extract the values from. Use * to extract values from all properties

• Use sub-properties: when set to true, the values of all sub properties are also included. Sub-properties can be defined in the data with the rdfs:subPropertyOf relation.

• Part: The date part to extract. From the example date 2024-09-01, the returned values for each option would be:

  • year: 2024

  • month: 9

  • day: 1

  • dayofyear: 245 (1st of January = 1)

  • weekofyear: 35 (1st week = 1)

  • dayofweek: 7 (Monday = 1)

  • yyyy-MM-dd:

    • String output: 2024-09-01 (date in ISO format)

    • Integer output: 1725141600 (Unix epoch: number of seconds that have passed since Thursday 1 January 1970 00:00:00 UT)

Output scores can be aggregated and/or normalised.