Re: Migrating from MSAccess

Thank you very much.
Sorry I haven't been clear enough: Data in MSAccess field reads "4:00:00 PM"
on screen. I don't know where on the way to PostgreSQL "PM" gets lost ;)
I will convert to military time prior to exporting.

-----Original Message-----
From: Eric G. Miller <egm2@jps.net>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Date: Friday, June 29, 2001 11:32 PM
Subject: Re: [GENERAL] 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>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly