I'm sure the subject sounds extremely confusing :)
I have a table which stores an event date. The event is stored as a standard mm/dd/yy entry.
I then need to calculate based on the dd value, WHICH day of the week that is (e.g. Wednesday) and which occurrence of that day of the week, within the month, it is (e.g. the THIRD Wednesday).
From there, I need to calculate, based on the previously obtained information, the mm/dd/yy DATE of next month's third Wednesday.
My business analyst has attempted a few various solutions but we seem to keep missing the mark, we've found tons of information for how to do it in a MySQL or MSSQL instance, but none on Postgres, or at least, none that have worked.
Any help would be appreciated, thanks!