[MonoTouch] Does MonoTouch's Sqlite support TIMESTAMP (93) data type?

[jGoff]

When I try and read a TIMESTAMP field from an Apple created Sqlite file I get
"Error querying database: Invalid format string".  I haven't given it a
format string.  I can read other fields, but it chokes on fields of type
TIMESTAMP.  Here's some code:

using (SqliteDataReader dbReader = sqlCom.ExecuteReader())
{
    if (dbReader.HasRows)
    {
        while (dbReader.Read())
         {
            string myFile   = Convert.ToString (dbReader["FILENAME"]);  //
this works
            string myDate = Convert.ToString (dbReader["DATECREATED"]);  //
this fails
 -------------------------

I think dbReader["fieldName"] is returning type OBJECT, so it shouldn't
really be complaining about "format string".

If this is a bug, does anyone know a work-around, i.e. a different query
command that isn't so picky?

Thanks,

Jim G.

--
View this message in context: http://monotouch.2284126.n4.nabble.com/Does-MonoTouch-s-Sqlite-support-TIMESTAMP-93-data-type-tp4439834p4439834.html
Sent from the MonoTouch mailing list archive at Nabble.com.