Re: [sqlite] Sqlite, vb6 and date time field
"Rene Claassen" 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
Re: [sqlite] Sqlite, vb6 and date time field
How can I convert it into a string through ODBC? Here is some of my data. Date_Stamp 2009/03/16 10:52 2009/03/16 14:18 2009/03/16 14:20 2009/03/16 14:43 2009/03/16 15:10 2009/03/16 15:17 2009/03/16 15:23 2009/03/16 15:30 2009/03/16 15:32 2009/03/16 15:47 Rene > -- Forwarded message -- > From: steven.far...@dds.net > To: General Discussion of SQLite Database > Date: Wed, 8 Apr 2009 10:23:38 -0400 > Subject: Re: [sqlite] Sqlite, vb6 and date time field > Can you provide maybe 10 samples of the dates on the database. Some > databases have a different date format and you might have to format the > date or convert it to a string and back into a date again. > > sqlite-users-boun...@sqlite.org wrote on 04/08/2009 06:20:09 AM: > Hi > > I received a Sqlite database from someone, and they also gave me > SQLite2008Pro together with the ODBC Driver. They want a front end to > view/query the data that I'm building in vb6. One of the fields is a > DateStamp with a datatype DateTime. When I try to display that field I get > an 'Invalid use of null' error (all the records have dates in that field). > I've also tried importing the data into Access, and it doesn't import any of > the dates. Can someone please help. > > Thank you, > Rene > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite, vb6 and date time field
Hello. The EzTools office is closed for 1 week holidays. Will be open again around 17 April. If you have purchase a product, we will process your order then. Sorry for any inconvenience. EzTools Support ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite, vb6 and date time field
Can you provide maybe 10 samples of the dates on the database. Some databases have a different date format and you might have to format the date or convert it to a string and back into a date again. sqlite-users-boun...@sqlite.org wrote on 04/08/2009 06:20:09 AM: > Hi > > I received a Sqlite database from someone, and they also gave me > SQLite2008Pro together with the ODBC Driver. They want a front end to > view/query the data that I'm building in vb6. One of the fields is a > DateStamp with a datatype DateTime. When I try to display that field I get > an 'Invalid use of null' error (all the records have dates in that field). > I've also tried importing the data into Access, and it doesn't import any of > the dates. Can someone please help. > > Thank you, > Rene > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sqlite, vb6 and date time field
Hi I received a Sqlite database from someone, and they also gave me SQLite2008Pro together with the ODBC Driver. They want a front end to view/query the data that I'm building in vb6. One of the fields is a DateStamp with a datatype DateTime. When I try to display that field I get an 'Invalid use of null' error (all the records have dates in that field). I've also tried importing the data into Access, and it doesn't import any of the dates. Can someone please help. Thank you, Rene ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users