On Fri, Jan 2, 2015 at 4:29 PM, Simon Davies <[email protected]> wrote:
> On 3 January 2015 at 00:12, J Decker <[email protected]> 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
