O$: Postgres, $createnames() and date fields

Kelly Burgess kellyb at montana.com
Thu Mar 5 01:44:06 EST 2015

Hi Paul,

According to the "Server-Specific Programming" docs for PostgreSQL, the data type mappings are -

Omnis to PostgreSQL:
  Short date (all subtypes)  -->  DATE
  Short time  -->  TIME
  Datetime (all subtypes)  -->  TIMESTAMP

PostgreSQL to Omnis:
  DATE  -->  Short date
  TIMESTAMP  -->  Datetime (#FDT)
  TIME  -->  Datetime (#FDT)

So you say you have a time (H:N) field - but that's actually a datetime field, not a short time.  So if you can change the Omnis type to short time, you should end up with TIME in postgres.


More information about the omnisdev-en mailing list