vendredi 23 janvier 2015

SQLite store current date with time set by defaut to 00:00:00

I have a SQLite table which one of its columns is:



timestamp long DEFAULT CURRENT_TIMESTAMP NOT NULL


It stores in database the UTC date and time but also the time. As time is not important for me how can I store it with time set to 00:00:00 by defaut?


Aucun commentaire:

Enregistrer un commentaire