From: | "Mihai Gheorghiu" <tanethq(at)earthlink(dot)net> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Migrating from MSAccess |
Date: | 2001-07-02 14:25:42 |
Message-ID: | 019901c10306$36bc9420$6e646464@New6.Travel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)jps(dot)net>
To: pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)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(at)jps(dot)net>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2001-07-02 14:30:41 | [PATCH] Resurrecting partial indicies, need help and feedback |
Previous Message | Doug McNaught | 2001-07-02 14:14:59 | Re: Compilation & Installation problem |