Re: [sqlite] How does a default value for fieldtype "time" look ?

"time" time NOT NULL DEFAULT HH:MM gets me that error: SQL Error: near ":MM": syntax error found this: 1. -MM-DD 2. -MM-DD HH:MM 3. -MM-DD HH:MM:SS 4. -MM-DD HH:MM:SS.SSS 5. -MM-DDTHH:MM 6. -MM-DDTHH:MM:SS 7. -MM-DDTHH:MM:SS.SSS 8.

[sqlite] How does a default value for fieldtype "time" look ?

Hello, I just created in sqlite database a field called time with fieldtype time. What should i set the time as default value maybe 00:00 ? doesnt work... -- View this message in context: http://www.nabble.com/How-does-a-default-value-for-fieldtype-%22time%22-look---tp20086163p20086163.html