Migrating from MSAccess
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
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>
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
Show quoted text
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
Import Notes
Resolved by subject fallback