Re: [web2py] datetime column with milliseconds precision

2014-04-02 Thread nick name
On Wednesday, February 12, 2014 5:11:29 PM UTC+2, Alex wrote: > > IS_DATETIME validator doesn't change anything. I doubt that validators are > used by the DAL. > I guess I have to use native sql to set milliseconds > (Better late than never ... I just saw this) You don't have to go directly to n

Re: [web2py] datetime column with milliseconds precision

2014-02-12 Thread Alex
IS_DATETIME validator doesn't change anything. I doubt that validators are used by the DAL. I guess I have to use native sql to set milliseconds? Alex On Wednesday, February 12, 2014 3:56:41 PM UTC+1, Manuele wrote: > > Il 10/02/14 12:06, Alex ha scritto: > > Is it possible to update a datetime

Re: [web2py] datetime column with milliseconds precision

2014-02-12 Thread Manuele Pesenti
Il 10/02/14 12:06, Alex ha scritto: > Is it possible to update a datetime column with milliseconds precision? > > e.g. I have a field > Field('invoice_date', 'datetime') > > and I'm updating the field: > now = datetime.datetime.now() > db(db.invoice.id == 743).update(invoice_date=now) > > the currr

[web2py] datetime column with milliseconds precision

2014-02-10 Thread Alex
Is it possible to update a datetime column with milliseconds precision? e.g. I have a field Field('invoice_date', 'datetime') and I'm updating the field: now = datetime.datetime.now() db(db.invoice.id == 743).update(invoice_date=now) the currren time contains milliseconds: 11:58:35.696000 In th