By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE eventtable("orgdate" TEXT);
INSERT INTO eventtable("orgdate") VALUES
('September 18, 2015'),
('September 5, 2015'),
('september 5, 2015');
UPDATE eventtable
SET orgdate =
SUBSTR(orgdate, -4) || '-' ||
CASE UPPER(SUBSTR(TRIM(orgdate), 1, 3))
WHEN 'JAN' THEN '01'
WHEN 'FEB' THEN '02'
WHEN 'MAR' THEN '03'
WHEN 'APR' THEN '04'
WHEN 'MAY' THEN '05'
WHEN 'JUN' THEN '06'
WHEN 'JUL' THEN '07'
WHEN 'AUG' THEN '08'
WHEN 'SEP' THEN '09'
WHEN 'OCT' THEN '10'
WHEN 'NOV' THEN '11'
WHEN 'DEC' THEN '12'
END || '-' ||
REPLACE(SUBSTR(SUBSTR(orgdate, 1, INSTR(orgdate, ',') - 1), -2), ' ', '0')
SELECT * FROM eventtable
| orgdate |
|---|
| 2015-09-18 |
| 2015-09-05 |
| 2015-09-05 |