"Rene Claassen" <claassen.r...@gmail.com>
schrieb im Newsbeitrag
news:64d5d370904090322t2f2b24f2pf8aafb4963fd0...@mail.gmail.com...
> How can I convert it into a string through ODBC? Here is some of my data.
>
> Date_Stamp
> 2009/03/16 10:52
> ...
I assume, this is a "textbased Date" - normally understandable
by most wrappers - but maybe in its current format it makes
some wrappers (the ODBC-wrapper here) choke, since it
does not contain the seconds - and maybe the slashes as
separators are also somewhat of a problem.
"Normal Text-Dates" follow the form:
Short-Date: '2009-03-16'
DateTime: '2009-03-16 10:52:00'
LongDateTime: '2009-03-16 10:52:00.123'
Anyway - speaking for my VB6-wrapper - I've just
tested it against a DateTime-column, which got your
somewhat "reduced" date-format as Text ('2009/03/16 10:52')
- and it correctly translates that date-string into a VB6-Date
(readable over the SQLite-Recordset).
Please check it out from:
www.thecommon.net/2.html
www.thecommon.net/3.html (contains the Download-Links)
Regards,
Olaf Schmidt
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
