Re: Postgresql and NSTimestamp
Re: Postgresql and NSTimestamp
- Subject: Re: Postgresql and NSTimestamp
- From: Art Isbell <email@hidden>
- Date: Wed, 5 Feb 2003 09:51:43 -1000
On Wednesday, February 5, 2003, at 01:59 AM, javier wrote:
I am trying to use Postgresql (Windows) with WebObjects (Mac OS X
10.2). In any tables i have fields typed as "timestamp with time zone"
and in EOModeler with "NSTimestamp".
JDBC doesn't support the timestamp with time zone data type, so if you
need to preserve time zone info, you'll need to create one timestamp
column and a second column to store the time zone abbreviation (e.g.,
"Europe/Madrid"). Then you'll need to do any necessary timestamp
conversions between GMT and the time zone whose abbreviation is stored
as you fetch and store the timestamp data.
A future version of JDBC is supposed to support timestamp with time
zone, but for now, things are sort of ugly which describes working with
Java in general.
Art
http://homepage.mac.com/aisbell/
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.