On Fri, Jan 2, 2015 at 4:29 PM, Simon Davies <simon.james.dav...@gmail.com> wrote:
> On 3 January 2015 at 00:12, J Decker <d3c...@gmail.com> wrote: > > Okay... > > https://www.sqlite.org/lang_datefunc.html > > > > https://www.sqlite.org/datatype3.html /* lists DateTime as a distinct > type > > */ > > Could you point out where exactly > > well there's no anchors NUMERIC DECIMAL(10,5) BOOLEAN DATE DATETIME I did Ctrl-F datet and it found it.... okay but that is 'this converts as this affinity... which if looked at from 'create table' https://www.sqlite.org/lang_createtable.html would miply that it loses meaning There is no datetime type; compare the columns using the datetime functions. > I.e datetime( col1) < datetime( col2 )... > > I tried that... it didn't seem to work... select datetime(col) is NULL... > If you don't use the datetime functions, then columns containing > datetime STRINGS will be compared using the text collation specified. > > Regards, > Simon > > > _______________________________________________ > 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