Reply to thread

Hi,

one small question:

How can I convert a C# DateTime into a number?

background:

I would like to store a date time into a SQLite table. Works fine, but I use a TEXT field.

=> Problem: SQL-sorting by this field is not possible!

=> idea: I'd like to store the date into a NUMBER field, so that a SQL-sort is possible (with an index on the field to boost it up).

Any ideas? Alternative workarounds?

Thanks!

Daniel