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 <sqlite-users@sqlite.org> > 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
