> > sqlite> select time( '2011-01-29 08:00:00' ); > 08:00:00 >
Oh sorry, i looked wrong. I insert this way: INSERT INTO [filed1] VALUES '2011-01-01 08:00:00' And because of the init of: CREATE TABLE tabel1 ( [field1] time, ); SQLite writes only the time to the database. But this fails: [field1] < TIME(NEW.TimeStamp) And I don't know why and if I do this: TIME( [field1] ) < TIME( NEW.TimeStamp ) It returns always exact the opposite of what I aspect. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
