lundi 12 janvier 2015

How can I strip '00:00:00' from a column in a table?

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