[sqlalchemy] Oracle timestamp and postgres datetime compatibility

2009-12-02 Thread drakkan
Hi all, I have a sa model working with postgres, here is a code fragment: class Test(Base): __tablename__ = 'test' fileld1= Column(Unicode(40), nullable=False, primary_key=True) date = Column(DateTime, nullable=False) in postgres the sqltypes.DateTime is converted in:

Re: [sqlalchemy] Oracle timestamp and postgres datetime compatibility

2009-12-02 Thread Michael Bayer
On Dec 2, 2009, at 8:48 AM, drakkan wrote: Hi all, I have a sa model working with postgres, here is a code fragment: class Test(Base): __tablename__ = 'test' fileld1= Column(Unicode(40), nullable=False, primary_key=True) date = Column(DateTime, nullable=False)

Re: [sqlalchemy] Oracle timestamp and postgres datetime compatibility

2009-12-02 Thread Ian Kelly
On Wed, Dec 2, 2009 at 3:25 PM, Michael Bayer mike...@zzzcomputing.com wrote: from the article:  Beware while the TO_CHAR function works with both datatypes, the TRUNC function will not work with a datatype of TIMESTAMP. This is a clear indication that the use of TIMESTAMP datatype should

Re: [sqlalchemy] Oracle timestamp and postgres datetime compatibility

2009-12-02 Thread Michael Bayer
On Dec 2, 2009, at 5:49 PM, Ian Kelly wrote: On Wed, Dec 2, 2009 at 3:25 PM, Michael Bayer mike...@zzzcomputing.com wrote: from the article: Beware while the TO_CHAR function works with both datatypes, the TRUNC function will not work with a datatype of TIMESTAMP. This is a clear