Re: Postgresql and NSTimestamp
Re: Postgresql and NSTimestamp
- Subject: Re: Postgresql and NSTimestamp
- From: Chuck Hill <email@hidden>
- Date: Wed, 05 Feb 2003 14:28:12 -0800
FWIW, the FrontBase JDBC driver has a hack to support timestamp with
timezone. It seems to work pretty well.
Chuck
At 09:51 AM 05/02/2003 -1000, Art Isbell wrote:
>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.
>
--
Chuck Hill email@hidden
Global Village Consulting Inc. http://www.global-village.net
_______________________________________________
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.