I have a data file I am trying to convert into either a SQL Server or Postgres database. How can I convert the following date field value into a string compatible with either a Postgres or SQL Server date field?
MONDAY, SEPTEMBER 21, 1942
I will give points for either a way in Postgres or SQL Server. Preferrably in T-SQL or pl/pg SQL