I recently migrated our application from MySQL to SQLite but since the migration I noticed something strange when storing time stamps.
Time stamps added when we were using MySQL look like 2015-01-01 00:00:00 but time stamps added when we were using SQLite look like 2015-01-01.
I do not need the 00:00:00 so it's not a problem, but how can I strip this from all existing rows from when we were using MySQL?
At the moment our column looks like:
user_EntryDate
--------------
2015-01-01 00:00:00
2015-01-02 00:00:00
2015-01-03 00:00:00
<switched to SQLite>
2015-01-04
2015-01-05
2015-01-06
Aucun commentaire:
Enregistrer un commentaire