[Mono-dev] [PATCH] Problem with sqlite in mono 1.1.13

[Aaron Bockover]

On Sun, 2006-01-22 at 20:06 -0500, Joshua Tauberer wrote:
> Why do you say that dates are in "yyyy-MM-dd HH:mm:ss" format?  It
> depends on how they were put into the database -- probably the local
> encoding if they're put in with DateTime.ToString(), right?

That's how they are stored as strings internally in sqlite. For
instance:

sqlite> SELECT DATETIME("NOW");
2006-01-23 01:25:11

But this brings up a good point: to properly write back to the database
in an UPDATE or INSERT on a DATETIME column, the DateTime object must be
converted to this format.

> Also, checking if the long fits into an int, the negative lower bound
> has to be checked too, I guess.  (Don't worry about resending a patch
> just for that tho.)

Oh, yes. My apologies :)

Cheers,
Aaron