java convert date from one timezone to another

Use Case:
Suppose you receive time string from one machine in  PST zone as "04-30-2015 07:00:00", the machine on which you receive this string data is in CST and you want to convert the time in EST.

If we use java.util.Date it will change the string into Date with reference to local machine timezone which is CST. i.e. it will look something like "04-30-2015 07:00:00 CST", so the conversion will something like below.

What will Happen
Time is EST  will be calculated as "04-30-2015 09:00:00 EST"

What is the perceived output
Time is EST  should be  "04-30-2015 10:00:00 EST"

Why It happens
java.util.Date does not take in reference of the timezone, for it time is absolute and Timezone is only interpreted as display property, and offset is applied on absolute time to print the timezone accordingly.

Solution

Use Joda time. If you are using maven include the following dependency.

 <dependency>
            <groupId>joda-time</groupId>
            <artifactId>joda-time</artifactId>
            <version>2.7</version>
    </dependency>

and use the following method: 

 public String convertTimeZones(Date fromDate, String frmTz, String toTz) {
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd hh.mm.ss");
      
        /*Convert the time string into a string with valid timezone appeneded to it*/
        String fromDateTime = df.format(fromDate) + " " +DateTimeZone.forTimeZone(TimeZone.getTimeZone(frmTz));
       
        DateTimeFormatter dtf = DateTimeFormat.forPattern("yyyy-MM-dd hh.mm.ss ZZZ");
        DateTimeFormatter fmt = DateTimeFormat.forPattern("E,MMM d yyyy hh:mm:ss zz");
        DateTime origDate = new DateTime(dtf.parseDateTime(fromDateTime));
        DateTime dtToTz = origDate.withZone(DateTimeZone.forTimeZone(TimeZone.getTimeZone(toTz)));
        return dtToTz.toString(fmt);
    }

Comments

Post a Comment

Popular posts from this blog

Caused by: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation

Many times we encounter this error and think that there might be some JPA issue or network issue. However, the error is pretty explicit in its nature, but still not clear to ring the bell very first time. As the error says there is a timeout, and since Oracle is saying, we shall accept it. Another clue is "user requested cancel of current operation". This means that the connection was closed by the application server not the database server, hence it can be safely concluded that application has configured timeouts on transactions at its end. However, if you feel that this transaction should have been concluded within the application server limits, your doubt might be true. This problem can arise in case there is a lock on the record being updated by JPA or lock on the table in which JPA is attempting to insert. The lock is most probably being held by some other application, and since application server configuration is on aggressive SLA, the transaction is waiting its...
Read more

pandas dataframe add missing date from range in a multi-dimensional structure with duplicate index

This solution demonstrates how to fill in the missing dates in a given range in a multi-index pandas dataframe. The complexity is added by the presence of duplicate dates in the given data, where the date is considered as an index. In case you try to reindex a data frame with duplicate indexes, you will get the following error. ValueError : cannot reindex from a duplicate axis To resolve this situation and to achieve the end goal of refitting dataset with missing indexes, following pseudo code can be used. Read multidimensional data into pandas dataframe (dataset), with date column as an index (only one index). Transform dataframe index created above into datetime index type Create a new dataframe (d) with the required date range, and value of other records as null Append 'd' into 'dataset' Set index of 'dataset' to include more column to create a multi-level index Reindex to 'dataset', and fill the desired value. The example python co...
Read more

Delete horizontal, vertical and angled lines from an image using Python to clear noise and read text with minimum errors

I was working on an algorithm to detect lines in a image. I found many solutions online, but none of them seem to work to my satisfaction. Thereafter, I decided to write an algorithm, which can work to my satisfaction. This algorithm can detect horizontal, vertical and angled lines. Following is the pseudo code of the algorithm. The implementation is in Python and it uses third party code. pix_array = Convert the image into 2D pixel array  Mono chromate the pixel array by setting values between 0-200 as 0 (black) and greater than 200 as 255(white) as  image_width = length of pix_array[0] image_height = length of pix_array Loop through pix_array, i.e. 1 pixel high horizontal slice of image: h = x coordinate of current pixel k = y coordinate of current pixel choose a value of radius as r draw a circle taking h,k as center using equation (X-h)^2 + (Y-k)^2 = r^2 derive values of X and Y and check if pix_arrY[X][Y] is black (0) if black add them to possible line c...
Read more