Re: need to update TimestampUtils code - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: need to update TimestampUtils code
Date
Msg-id FD33D2A9-046F-4664-87FE-5612A0470DEC@fastcrypt.com
Whole thread Raw
In response to need to update TimestampUtils code  ("Do, Leon (Leon)" <leondo@alcatel-lucent.com>)
Responses Re: need to update TimestampUtils code
Re: need to update TimestampUtils code
List pgsql-jdbc
Does the server ever send us hhmm without a colon ?

Or what is the use case for this.

Either way you need to send us a context diff 

Dave
On 4-Jan-07, at 2:28 PM, Do, Leon (Leon) wrote:

Hi,

 

Can someone help me to update this small block of code (see BEGIN and END block) in the TimestampUtils class or tell me the direction to do it?  The code allow the util to parse the timezone in both format hhmm or hh:mm.   

 

            // Possibly read timezone.

            sep = charAt(s, start);

            if (sep == '-' || sep == '+') {

                int tzsign = (sep == '-') ? -1 : 1;

                int tzhr, tzmin;

   

                end = firstNonDigit(s, start+1);    // Skip +/-

 

                //CHANGES BEGIN

                //if 4 digits together

                if (end - (start+1) > 2) {

                    //get first 2 digits as tzhr

                    tzhr = number(s,start+1,start+1+2);

                    // get the rest of digits as tzmin

                    tzmin= number(s,start+1+2, end);

                    start=end;

                } else {

                //CHANGES END

 

                    tzhr = number(s, start+1, end);

                    start = end;

 

                    sep = charAt(s, start);

                    if (sep == ':') {

                        end = firstNonDigit(s, start+1);  // Skip ':'

                        tzmin = number(s, start+1, end);

                        start = end;

                    } else {

                        tzmin = 0;

                    }

                }

              

                // Setting offset does not seem to work correctly in all

                // cases.. So get a fresh calendar for a synthetic timezone

                // instead

                result.tz = getCalendar(tzsign, tzhr, tzmin);

 

                start = skipWhitespace(s, start);  // Skip trailing whitespace

            }

 

 

thanks

 

 

Leon Do

Lucent Technologies

Mobility Software Engineer

 

 



pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Support for DatabaseMetadata: getCatalogName, getTableName,
Next
From: Kris Jurka
Date:
Subject: Re: need to update TimestampUtils code