PostgreSQL Timestamps

Aus MHC-Wiki

My first guess was to create timestamp columns like this:

comumn_name  timestamp,

This works perfectly as long as you do not want to read a column of type timestamp with Omnis and later write it back to the database. If you try this Omnis wants to write some thing like this:

04-15-2009 11:54:45.-78

to the database. This fails. If you want working timestamps you have to create them like this:

comumn_name  timestamp(0),

With precision 0. With this data definition you will be able to wirte timestamps back to the database with Omnis.