Thread

1. Migrating from MSAccess

   Mihai Gheorghiu <tanethq@earthlink.net> — 2001-06-29T15:44:52Z

   Trying to export a Long Time field from MSAccess to a Time field in
   PostgreSQL.
   In Access I have 4:00:00 PM   In PostgreSQL I get 4:00:00  (no PM).
   What am I missing?
   
   TIA,
   
   Mihai Gheorghiu
   
   
   

2. Re: Migrating from MSAccess

   Eric G. Miller <egm2@jps.net> — 2001-06-30T03:22:08Z

   On Fri, Jun 29, 2001 at 11:44:52AM -0400, Mihai Gheorghiu wrote:
   > Trying to export a Long Time field from MSAccess to a Time field in
   > PostgreSQL.
   > In Access I have 4:00:00 PM   In PostgreSQL I get 4:00:00  (no PM).
   > What am I missing?
   
   Depending on what you're doing, Access may be assuming am/pm stuff.
   
   To PostgreSQL, 4:00:00 is 4am, of course; whereas 16:00:00 is 4pm.
   
   It's hard to know the context, but you may want to use Access's format()
   function to either convert to 24hr time or insure the AM/PM is actually
   getting passed to PostgreSQL.
   
   -- 
   Eric G. Miller <egm2@jps.net>