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

Paul Mulroney pmulroney at logicaldevelopments.com.au
Thu Mar 5 21:53:18 EST 2015

Hi Kelly,

On 06/03/2015, at 1:00 AM, omnisdev-en-request at lists.omnis-dev.com wrote:

>> So, how do I get the $createnames() method to recognise time fields as a Time, and date fields as a Date?

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

Thanks!  I'll give that  go!


Did you know that the urge to sing The Lion Sleeps Tonight is only ever a whim away? @markedw on Facebook
Paul W. Mulroney                                                   We Don't Do Simple Pty Ltd 
pmulroney at logicaldevelopments.com.au        Trading as Logical Developments
www.logicaldevelopments.com.au			   ACN 161 009 374 
Ph: +61 8 9458 3889						   86 Coolgardie Street
Fax: +61 8 9458 2169                       			   BENTLEY  WA  6102

More information about the omnisdev-en mailing list