Hi Igor,
>
> Yes. You can use any expression. AND and OR are operators, just like + or =
>
Ok, thank you good to know.
>
> SQLite doesn't have a dedicated "time" type. There are many ways to store
> time values - e.g. as a string '12:34', or as a number of seconds from
> midnight.
> How exactly do you put your time values into the field?
>
I create the table in this way:
CREATE TABLE tabel1 (
[field1] time,
);
I insert data in this way (for example):
INSERT INTO [filed1] VALUES TIME('29-01-2011 08:00:00')
>
> TIME() produces a string of the form '12:34:56' (hours:minutes:seconds).
> What's in NEW.TimeStamp? What's in field1?
>
NEW.TimeStamp is a complete datetime. But I only want to compare the time part
in my trigger.
--
Steffen Mangold
_______________________________________________
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
