PostgreSQL provider does not support datetime about pygeoapi

[tomkralidis]

1. same request, so works
2. returns The requested URL was rejected. Please consult with your administrator.. I am guessing there is something before pygeoapi that is returning this error (likely the ../ in the URL)
3. returns Configured times should be RFC3339 error

[KoalaGeo]

We've been doing datetime filters using CQL like:

1. https://ogcapi.bgs.ac.uk/collections/sensor-water-level-sta/items?f=json&limit=5&sortby=-resulttime&properties=resulttime,result,location_name
2. https://ogcapi.bgs.ac.uk/collections/sensor-water-level-sta/items?f=json&limit=5&filter=resulttime%20BEFORE%202024-04-06T22:30:00Z&sortby=-resulttime&properties=resulttime,result,location_name
3. https://ogcapi.bgs.ac.uk/collections/sensor-water-level-sta/items?f=json&limit=5&filter=resulttime%20AFTER%202024-04-07T22:30:00Z&sortby=-resulttime&properties=resulttime,result,location_name

[tomkralidis]

The equivalent queries using the datetime parameter would be:

1. https://ogcapi.bgs.ac.uk/collections/sensor-water-level-sta/items?f=json&limit=5&sortby=-resulttime&properties=resulttime,result,location_name (same)
2. https://ogcapi.bgs.ac.uk/collections/sensor-water-level-sta/items?f=json&limit=5&datetime=../2024-04-06T22:30:00Z&sortby=-resulttime&properties=resulttime,result,location_name
3. https://ogcapi.bgs.ac.uk/collections/sensor-water-level-sta/items?f=json&limit=5&datetime=2024-04-07T22:30:00Z/..&sortby=-resulttime&properties=resulttime,result,location_name

[KoalaGeo]

Ah i see....

{
"code":"InvalidParameterValue",
"description":"Configured times should be RFC3339"
}

[KoalaGeo]

2. Is allowed through now (pedantic F5....) now same error as 3.

[tomkralidis]

FYI @david-i-berry has a fix and will test/issue a PR in the next few days (thanks Dave).

[webb-ben]

Related to #1607