I am looking for a simple way of using date and time values with
sqlite3. I have some Ctime classes (VC++.net) which have to be stored
in
the database and they should be compared.
If the class you're using has .Value property, or a way to easily
transform the date from one format to another, you should probably store
that. For instance, I like to store dates in string format, using
something like "CCYYMMDDHHmmSS.SSSSSS". If I expect to need to deal with
time zones, I'll store all the dates/times as GMT, or Universal time,
and do the conversions when I create the datetime objects.
