Test it and validator not error :
IS_DATE(format=T('%Y/%m/%d %H:%M:%S'),error_message=T("Formato pretendido
aaaa/mm/dd HH:MM:SS"))("2013/09/25 09:54:24")
Out[17]: (datetime.date(2013, 9, 25), None)
In [18]: IS_DATE(format=T('%Y/%m/%d %H:%M:%S'),error_message=T("Formato
pretendido aaaa/mm/dd HH:MM:SS"))("2013/09-25 09:54:24")
Out[18]: ('2013/09-25 09:54:24', 'Formato pretendido aaaa/mm/dd HH:MM:SS')
2013/9/11 António Ramos <ramstei...@gmail.com>
> The field was only date and i changed it to datetime afer realised i
> needed the time
>
>
>
> 2013/9/11 Niphlod <niph...@gmail.com>
>
>> 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 web2py+unsubscr...@googlegroups.com.
>> 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 web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
--
Federico Ferraro
Usuario Linux : 482533.
--
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
