View Single Post

   
  #10 (permalink)  
Old 04-12-2008, 06:00 AM
Joachim Wieland
 
Posts: n/a
Default Re: invalid input syntax for type timestamp.

On Fri, Dec 15, 2006 at 11:37:56AM -0500, Tom Lane wrote:
> Joachim Wieland <joe@mcknight.de> writes:
> > Appended is a patch that adds JST and JDT into Asia.txt and the Default set.


> Um ... is there a JDT? Last I heard, Japan does not observe daylight
> time. I don't see a JDT in the old PG set of recognized zone names, and
> I'd think we'd have heard complaints long ago if it were needed.


True... Actually I wonder how I have to read the zic files in this case.
It says:

Rule Japan 1948 only - May Sun>=1 2:00 1:00 D
Rule Japan 1948 1951 - Sep Sat>=8 2:00 0 S
Rule Japan 1949 only - Apr Sun>=1 2:00 1:00 D
Rule Japan 1950 1951 - May Sun>=1 2:00 1:00 D

Zone Asia/Tokyo 9:18:59 - LMT 1887 Dec 31 15:00u
9:00 - JST 1896
9:00 - CJT 1938
9:00 Japan J%sT

The last column of the rules tell us what to put in for %s, but why is there
no

Rule Japan 19xx max .... S

rule? I.e. a rule saying that after some date we should always replace %s
by S? What am I missing here?


Joachim



---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Reply With Quote