• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Postgresql and NSTimestamp
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.

References: 
 >Postgresql and NSTimestamp (From: javier <email@hidden>)
 >Re: Postgresql and NSTimestamp (From: Art Isbell <email@hidden>)

  • Prev by Date: question about webobjects manual (Chap 6-web application)
  • Next by Date: Java Client beginner question
  • Previous by thread: Re: Postgresql and NSTimestamp
  • Next by thread: Limiting Punctuation Characters In Code
  • Index(es):
    • Date
    • Thread