Add timezone offset to java date

Question

I have a requirement to add my local timezone offset to a date that I am reading from the database (i.e. the business date field below) which will then be tranformed into an epoch date (businessDate.getTime()).

public List<Long> mapRow(ResultSet rs, int rowNum) throws SQLException {
    Date businessDate = rs.getDate(BUSINESS_DATE);
    Integer numberOfTxns = rs.getInt(TRAN_COUNT);

    List<Long> count = new ArrayList<Long>();
    count.add(businessDate.getTime());
    count.add(new Long(numberOfTxns));

    return count;
}

thanks

Evgeniy Dorofeev · Accepted Answer · 2015-02-23 06:22:30Z

1

You can get time zone offset this way

    int offsetInMilliseconds = TimeZone.getDefault().getOffset(date.getTime());

answered Feb 23, 2015 at 6:22

Evgeniy Dorofeev

137k31 gold badges209 silver badges288 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Richie Over a year ago

So I should just be able to add that offset to my businessDate.getTime() and that will return the unix time stamp with a time zone offset?

Evgeniy Dorofeev Over a year ago

To be exact, you will get the number of milliseconds since January 1, 1970, 00:00:00 GMT + local time zone offset in milliseconds

Collectives™ on Stack Overflow

Add timezone offset to java date

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related