I use a GeoServer which i query over Openlayers with WMS and CQL.
I have a date field in my database which i want to filter with CQL.
I want only have Dates which has the weekday monday.
The Result would contain only two dates.
id time 1 12.10.2015 12:26:31 2 19.10.2015 13:45:00 3 20.10.2015 12:16:11 4 21.10.2015 12:03:45 5 22.10.2015 12:01:45
I don't see any way to do that. Are the some functions to do that? I was thinking of use a formular to calculate the weekday, but therefore i need the day, month, year and century from a date and i don't see any way to extracts this values.