What is the ArcGIS SQL expression to select all rows containing the month of May across several years?
The source table is in a file geodatabase and I'm using ArcGIS Pro v2.2.4.
Attempts so far
I tried using the wildcard characters for strings listed in the Pro SQL reference but they (unsurprisingly) yield "invalid syntax" error:
SAMPLE_DATE = date '%-05-%' SAMPLE_DATE = date '__-02-__'
KB article How To: Search for specific parts of a date stored in a Date-Time field offers
EXTRACT(MONTH ...) = nn but that returns zero records.
EXTRACT(MONTH FROM SAMPLE_DATE) = 05