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
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