I have date stored as string in an sqlite database like "8/11/2008 09:17:02". I want to convert the string to date. For SALETIME column, how can I change the data type from string to a date type? Using SQLite and the UPDATE clause how can I change all values in SALETIME column to a format like "YYYY-MM-DD HH:MM:SS"

SALETIME sqlite> SELECT ..> FROM sales .> LIMIT 10; SALESID LISTID SELLERID 1 1 36861 21191 2 4 8117 11498 3 5 1616 17433 5 1616 19715 6 47402 14115 10 24858 24888 10 24858 7952 8 10 24858 19715 9 10 24858 29891 10 12 45635 10542 BUYERID EVENTID DATEID 7872 1875 4 4337 1983 2 8647 1983 2 8647 1986 1 8240 2069 2 3375 2023 2 3375 2003 4 3375 2017 1 3375 2029 3 4769 2044 1 QTYSOLD PRICEPAID COMMISSION 728 109.2 2/18/2008 02:36:48 76 11.4 6/6/2008 05:00:16 350 52.5 6/6/2008 08:26:17 175 26.25 6/9/2008 08:38:52 154 23.1 8/31/2008 09:17:02 394 59.1 7/16/2008 11:59:24 788 118.2 6/26/2008 12:56:06 197 29.55 7/10/2008 02:12:36 591 88.65 7/22/2008 02:23:17 65 9.75 8/6/2008 02:51:55