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

"PEL" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "time" time NOT NULL DEFAULT HH:MM What's that supposed to achieve? If you want current time in HH:MM format, make it DEFAULT (strftime('%H:%M', 'now')) If you want, say, midnight in HH:MM format, make it DEFAULT '00:00'

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.

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

"PEL" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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... http://article.gmane.org/gmane.comp.db.sqlite.general/38853 Figure out how

[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