dimanche 4 octobre 2015

SQLite field type conversion

Can anyone shed some light / details on the following observations: If u have a string colunm which has values representing a date in the form of Y-m then convert that column to the date type I noticed the following: 1 - Performing a SELECT will show 1899-12-30 as the value for that specific column 2 - Performing a SELECT using strftime will show the date as it was before the conversion

Aucun commentaire:

Enregistrer un commentaire