Problem updating Time Type field

[ljCharlie]

Here's a query I tried and doesn't work for me.

UPDATE activities SET ljTime=19:00:00 WHERE actID=05052003

I have also tried this:

UPDATE activities SET ljTime=07:00:00 [PM] WHERE actID=05052003

But I still receive the error:
[txoov] ERROR 1064: You have an error in your SQL syntax near ':00:00 WHERE actID=05052003' at line 1

Please help!

Many thanks in advance!

ljCharlie

[raf]

Did you try
UPDATE activities SET ljTime='19:00:00' WHERE actID=05052003

[ljCharlie]

Thanks! I got it working now.

ljCharlie