[sqlalchemy] Re: timestamp as int

2009-07-02 Thread Wayne Witzel
For mySQL you could use unix_timestamp() For Postgres you could use date_part('epoch',now()) I've always used DateTime personally and have only ever reflected tables that used Integer timestamps. So I can't speak to the drawbacks or potential impacts with any authority. There may also be a more

[sqlalchemy] Re: timestamp as int

2009-07-02 Thread Didip Kerabat
If you define your column as DateTime, then SA will use the db's datetime column. If you want to store time in integer, i think you can just set the column to integer, and set the column value as int(time.time()) - Didip - On Thu, Jul 2, 2009 at 9:52 AM, Lukasz Szybalski