Re: Migrating from MSAccess

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>