https://bugs.freedesktop.org/show_bug.cgi?id=50575
--- Comment #8 from Heinz Repp <heinz.r...@arcor.de> 2012-06-07 14:27:14 PDT ---
It is true that Sqlite has no datatype for timestamps (or any date or time
data). The page mentioned by Terrence says:
> SQLite does not have a storage class set aside for storing dates and/or times.
> Instead, the built-in Date And Time Functions of SQLite are capable of storing
> dates and times as TEXT, REAL, or INTEGER values:
>
> - TEXT as ISO8601 strings ("YYYY-MM-DD HH:MM:SS.SSS").
> - REAL as Julian day numbers, the number of days since noon in Greenwich on
> November 24, 4714 B.C. according to the proleptic Gregorian calendar.
> - INTEGER as Unix Time, the number of seconds since 1970-01-01 00:00:00 UTC.
I could not find any hint which datatype Sqlite chooses when creating a table
with timestamp columns, but it seems they all are strings:
> sqlite> select typeof(ts) from byTs;
> text
In my case, Sqlite lists my timestamps with one decimal, as in '2008-01-11
19:43:50.0', presumable the format that a previous version of sqliteodbc had
written, and as you confirmed the new versions feed more decimal places to the
sqlite library and get an empty result as this is a different string.
Seems what I need is not achievable with sqlite/sqliteodbc: in the input form I
need valid timestamps (and correct conversion when e.g. pasting from Calc), but
the database needs strings with exact match. I would have to write my own
conversion function.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
