I am trying to select a specific day in the "Select by attributes" tool. I know you can select using a day from 0-31 like this:
EXTRACT(DAY FROM "TimeStampStart") = 5
But I was wondering is there a way to select a specific day in the week (sunday to saturday)? for example select only days of week = tuesday?
P.S This is not the answer I am looking for: https://pdgisusers.org/2010/12/15/extract-day-of-the-week-from-a-date-field-in-arcgis/
and already looked into this :http://support.esri.com/technical-article/000011531