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(at)jps(dot)net>