On Wednesday 14 October 2009 02:51:07 pm Adrian Klaver wrote: > On Tuesday 13 October 2009 2:11:28 pm John wrote: > > On Tuesday 13 October 2009 01:34:08 pm Adrian Klaver wrote: > > > On Tuesday 13 October 2009 12:18:10 pm John wrote: > > > > OK I think Larry has discovered the problem but not the solution. > > > > Drop the 'group by' and the select returns dates instead of string. > > > > Also if 'DISTINCT' is use and not 'GROUP BY' it works - returns > > > > dates. Also using all the fields in the 'GROUP BY 1,2,3,4,5,6' does > > > > not work either. > > > > > > > > Johnf > > > > > > This is for the Windows case right? > > > > Yes - We get a string for the dates when the select statement contains > > a 'GROUP BY' on windows XP and VISTA. > > > > Johnf > > Something about passing the data through sqlite is different between the > Windows and Linux versions. You might want to check what version of sqlite3 > is installed on each machine. The sqlite version listed in your previous > email is for the pysqlite/sqlite3 module. The sqlite version should be > 3.X.X .
OK using sqlite3.sqlite_version from python produces Windows 3.3.4 Linux 3.5.7 Interesting but is there something I do about the windows being behind the linux version. It's part of the install routine for python (windows). Johnf _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/200910141500.34920.jfabi...@yolo.com