I use TIMESTAMP datatype, disply format is according to local cuture setting ex: 27.1.2012 13:50:32. all compare type is same.
Pavel Simon Slavin-3 wrote: > > > On 30 Jan 2012, at 11:16am, Pawl wrote: > >> | 05.01.2011 | 7.7 | 01.05.2011| 0.7 | 12.1 | >> +------------+-------+-----------+----------+-----------+ >> ... >> >> I tried to use cmd JOIN in this content, but didn't work it. >> >> SELECT JX.*,JX_lim.* FROM JX JOIN JX_lim ON JX_lim.edittime <= >> JX.starttime > > Your dates are stored in with the components in an unuseful order. SQLite > doesn't have a datetime format. Values like the ones above will probably > be stored as strings. If you want your SELECT to work (and I don't think > there's anything wrong with it) then your dates should be stored in a > format like > > "20110105" (string) > "2011/01/05" (string) > "2011-01-05" (string) > unix epoch (floating point) > juliandate (integer) > > You have to store all dates in the same format, so pick one of the above > (or something similar) and be consistent. > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/joint-two-table-tp33228376p33228881.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
