Convert PST to user time zone, for instance CST for china

Convert PST to user time zone, for instance CST for china - using java

Hi,

Can anyone assist me to convert a date (PST) that is read from Oracle db to user's local time? For instance when PST is 22 Dec 2008, CST(china) is 23 Dec 2008.

Things are working fine when I create a java.util.Date object and convert the same (the commented line in the code) .

Thanks in advance.

java.sql.Date templateDate = resultSet.getDate(RTQ_DATE_CREATED_INDEX);
...
...
...
calDate = Calendar.getInstance();
calDate.setTime(templateDate);
//calDate.setTime(new Date(new java.util.Date().getTime()));
createdDate = convertDateToUserTZ(calDate, tz, locale);
tz --> user's timezone
locale --> user's locale
 
 
public static String convertDateToUserTZ(Calendar cal, TimeZone tz, Locale locale) {
    	String pattern = "yyyy-MM-dd";		
	SimpleDateFormat sdf = new SimpleDateFormat(pattern);
	sdf.setTimeZone(tz);
	try {
		return sdf.format(cal.getTime());
	} catch (Exception e) {
		logger.error("Exception while parsing the date");
	}
	return null;
}

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:

Select all Open in new window

Instant Access to this Solution

Plus...

30 Day FREE access, no risk, no obligation

Collaborate with the world's top tech experts

Unlimited access to our exclusive solution database

Never be left without tech help again

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

"The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.

"Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin

"Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

public static String convertDateToUserTZ(Calendar cal, TimeZone tz, Locale locale) { Calendar copy = Calendar.getInstance(); copy.setTimeInMillis(cal.getTimeInMillis()); copy.set(Calendar.ZONE_OFFSET, tz.getRawOffset()); String pattern = "yyyy-MM-dd"; SimpleDateFormat sdf = new SimpleDateFormat(pattern); try { return sdf.format(copy.getTime()); } catch (Exception e) { logger.error("Exception while parsing the date"); } return null; }

Guys,

Thank you for the response. My code worked after I modify my query to get the date.

Previous query : SELECT DATE_LAST_EXECUTED
resultSet.getDate(1) was returning "2008-12-22" which is equal to Mon Dec 22 00:00:00 PST 2008. As the hh:mm:ss is 0 the date is displaying incorrectly.

modified query : SELECT to_char(DATE_LAST_EXECUTED, 'dd/mm/yyyy hh:mm:ss am')
I read the date as a string with above query and converted it to a PST calendar using "dd/mm/yyyy hh:mm:ss a". Then I converted the calendar to user's TZ date.

String createdDate = resultSet.getString(RTQ_DATE_CREATED_INDEX);
CalendarcalDate = DateUtil.getPSTCalendar(createdDate, "dd/mm/yyyy hh:mm:ss a");
createdDate = DateUtil.convertDateToUserTZ(calDate, tz, locale);
System.out.println("Date : " + createdDate );
 
 
public static Calendar getPSTCalendar(String dateString, String pattern)throws PPException {
    TimeZone tz = TimeZone.getTimeZone("PST");
    Locale locale = Locale.US;    	
    return getCalendar(dateString, tz, locale, pattern);
}
 
public static Calendar getCalendar( String dateString, TimeZone timeZone, Locale locale, String pattern ) throws Exception {
    try {
        SimpleDateFormat sdf = new SimpleDateFormat( pattern, locale );
        sdf.setLenient( Boolean.FALSE.booleanValue( ) );
        sdf.setTimeZone(timeZone);
        Calendar cl = Calendar.getInstance( timeZone, locale );
        Date dt = sdf.parse( dateString );
        cl.setTime( dt );
        return cl;
    } catch ( ParseException pe ) {
            throw new Exception ( "Error" );
    }
}// getCalendar
 
 
public static String convertDateToUserTZ(Calendar cal, TimeZone tz, Locale locale) {
    String pattern = "yyyy-MM-dd";
    SimpleDateFormat sdf = new SimpleDateFormat(pattern);
    sdf.setTimeZone(tz);
    try {
        return sdf.format(cal.getTime());
    } catch (Exception e) {
        // exception
    }
        return null;
}

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:

Select all Open in new window

Question

Convert PST to user time zone, for instance CST for china - using java

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

Java

Java Programming Language

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Need individual assistance?

Our experts are ready to help.

Want to learn from the best?

Read articles from industry experts.

Working on a long term project?

Store your work and research.

What Makes Experts Exchange Unique?

Trusted by the world's most respected brands.

Faithfully serving IT professionals since 1996.

Related Solutions

Free Tech Articles

Cloud Class Webinars

Join the Community

Give a Little. Get a Lot.

Answers

3 Ways to Join

The Experts

The Experts

Testimonials

Testimonials

Testimonials

Business Clients

Business Clients

In the Press

In the Press

In the Press