[sqlalchemy] Re: sqlite func,datetime

2007-07-06 Thread Nick
thanks, but that didn't work either. In the end i changed the func.db call to a datetime.datetime.now() python call which seems to work. I also noticed that i had to change all my date inserts to datetime objects as well (previously i was using postgres and inserted dates as date strings i.e.

[sqlalchemy] Re: sqlite func,datetime

2007-07-06 Thread Ian Charnas
On Jul 6, 7:06 am, Nick [EMAIL PROTECTED] wrote: thanks, but that didn't work either. In the end i changed the func.db call to a datetime.datetime.now() python call which seems to work. I also noticed that i had to change all my date inserts to datetime objects as well (previously i was

[sqlalchemy] Re: sqlite func,datetime

2007-07-05 Thread Michael Bayer
On Jul 5, 2007, at 6:00 AM, Nick wrote: class TestC(Entity): with_fields( name= Field(Unicode(50), nullable=False), created = Field(TIMESTAMP(timezone=True), default=func.datetime('now', 'localtime')) ) set up the func as func.datetime('now', 'localtime',