I have a column named Date with 100 rows in my SQlite Database. It is in the format 12-31-2012 16:34:17 p.m.
I need to replace that with 12-31-2012 16:34:17 pm How to acheive this ?
I have thought of update command but im confused how to do this.
Replace p.m. by pm in rows containing dates ending with p.m.
UPDATE <tablename> SET Date=REPLACE(Date, 'p.m.', 'pm')