How to replace one string with another in SQLite?

advertisements

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')

Not Tested