> I insert data in this way (for example):
>
> INSERT INTO [filed1] VALUES TIME('29-01-2011 08:00:00')
Result of TIME('29-01-2011 08:00:00') is NULL. So your field1 doesn't
contain anything. Maybe that's why your comparison doesn't work.
Pavel
On Tue, Nov 22, 2011 at 11:57 AM, Steffen Mangold
<steffen.mang...@balticsd.de> wrote:
> 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
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
