samedi 7 mai 2016

SQLite: Extract time from string using strftime

I have database column with time (string is used as data type of the column) in this format '30.09.2014 09:03:01'. I'd like to get timestamp from that column using:

SELECT id, strftime('%d.%m.%Y %H:%M:%S', date) AS time FROM table;

But I get empty column with time. I think there is a problem with dots as a separators. Can anyone help me with that?

Aucun commentaire:

Enregistrer un commentaire