The field was only date and i changed it to datetime afer realised i needed the time
2013/9/11 Niphlod <[email protected]> > data will always be stored in ISO format. SQLite in addition stores > datetimes as strings 'cause there's no datetime native field. > Did you change the field after creating it ? Does this error happen also > on a clean database ? > > > On Wednesday, September 11, 2013 10:58:56 AM UTC+2, Ramos wrote: >> >> my db.py >> db.define_table('oco', >> Field('created_on', 'datetime', required=True,label='Data'), >> ... >> ... >> >> db.oco.created_on.requires=[**IS_DATE(format=T('%Y/%m/%d %H:%M:%S'), >> error_message=T("Formato pretendido aaaa/mm/dd HH:MM:SS"))] >> >> >> I create a record with created_on set to >> >> 2013/09/25 09:54:24 >> >> I get this error >> >> >> >> 1. >> 2. >> 3. >> 4. >> 5. >> 6. >> 7. >> 8. >> 9. >> 10. >> 11. >> 12. >> 13. >> 14. >> 15. >> 16. >> 17. >> 18. >> 19. >> 20. >> 21. >> 22. >> 23. >> 24. >> >> Traceback (most recent call last): >> >> >> >> File "C:\web2py2\gluon\restricted.**py", line 209, in restricted >> >> >> >> exec ccode in environment >> File "C:/web2py2/applications/**empre/controllers/default.py" >> <https://apps.cires.pt/admin/default/edit/empre/controllers/default.py>, >> line 1120, in <module> >> >> >> >> File "C:\web2py2\gluon\globals.py", line 186, in <lambda> >> >> >> >> self._caller = lambda f: f() >> >> >> >> File "C:/web2py2/applications/**empre/controllers/default.py" >> <https://apps.cires.pt/admin/default/edit/empre/controllers/default.py>, >> line 486, in index >> >> >> >> for oco in db(db.oco.rel_trab.contains(tr**ab.id)).select(): >> >> >> >> File "C:\web2py2\gluon\dal.py", line 8766, in select >> >> >> >> return adapter.select(self.query,fiel**ds,attributes) >> >> >> >> File "C:\web2py2\gluon\dal.py", line 2094, in select >> >> >> >> return super(SQLiteAdapter, self).select(query, fields, attributes) >> >> >> >> File "C:\web2py2\gluon\dal.py", line 1594, in select >> >> >> >> return self._select_aux(sql,fields,at**tributes) >> >> >> >> File "C:\web2py2\gluon\dal.py", line 1559, in _select_aux >> >> >> >> self.execute(sql) >> >> >> >> File "C:\web2py2\gluon\dal.py", line 1671, in execute >> >> >> >> return self.log_execute(*a, **b) >> >> >> >> File "C:\web2py2\gluon\dal.py", line 1665, in log_execute >> >> >> >> ret = self.cursor.execute(*a, **b) >> >> >> >> File "c:\Python27\lib\sqlite3\**dbapi2.py", line 63, in convert_date >> >> >> >> return datetime.date(*map(int, val.split("-"))) >> >> >> ValueError: invalid literal for int() with base 10: '25 00:00:00' >> >> I see that in my sqlite file the date was set to 2013-09-25 00:00:00 >> instead of 2013/09/25 09:54:54 >> >> What i wrong? >> >> >> >> >> -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
