I have a table that I have created (in models) using
db.define_table('myTable',
Field('start', type='datetime', requires=NE)
)
I have some records in this table, in this format: '2015-12-31 00:00:00' (this
is on id = 1)
I want to run a query that will add one hour to this time, for each row.
db(db.myTable.id == 1).update(start = db.myTable.start + timedelta(hours=1))
But when I execute the above query, it changes the start value to '2015-12-31
00:00:01'. And if I run the same query again it changes it to '0000-00-00
00:00:00'. What am I doing wrong here and how can I fix this?
--
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/d/optout.
