"time" time NOT NULL DEFAULT HH:MM
gets me that error:
SQL Error: near ":MM": syntax error
found this:
1. YYYY-MM-DD
2. YYYY-MM-DD HH:MM
3. YYYY-MM-DD HH:MM:SS
4. YYYY-MM-DD HH:MM:SS.SSS
5. YYYY-MM-DDTHH:MM
6. YYYY-MM-DDTHH:MM:SS
7. YYYY-MM-DDTHH:MM:SS.SSS
8. HH:MM
9. HH:MM:SS
10. HH:MM:SS.SSS
11. now
12. DDDD.DDDD
so I used HH:MM or hh:mm in my sqlite database designer but it doesnt
compile :/
--
View this message in context:
http://www.nabble.com/How-does-a-default-value-for-fieldtype-%22time%22-look---tp20086163p20089380.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users