Joe
That worked wonderfully. As you said I will have to take into account the
various types (e.g., TIMESTAMP,DATETIME,TIME) but it fits my need well.
Thank you!
Lee
On Fri, 10 Jul 2015 at 17:34 Joe Mistachkin <joe at mistachkin.com> wrote:
>
> Lee Reiber wrote:
> >
> > Is there a way on connection to use a flag to GetAllAsTextIfDateTime ?
> >
>
> The following might be able to help:
>
> SQLiteConnection connection = new SQLiteConnection(
> "Data Source=C:\\some\\path\\test.db;Flags=UseConnectionTypes;");
>
> connection.AddTypeMapping("DATETIME", DbType.String, true);
>
> Please note that you may need to add more mappings if the DateTime type
> names you need are not always "DATETIME".
>
> Also, please let us know if this works for you.
>
> --
> Joe Mistachkin
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
