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(trab.id)).select():
>
>
> File "C:\web2py2\gluon\dal.py", line 8766, in select
>
>
> return adapter.select(self.query,fields,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,attributes)
>
>
> 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.
