[PHOENIX-997] Timestamp date type default format with GMT time zone

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.0.0
• Assignee: Unassigned
• Reporter: jay wong
• Created: 22/May/14 10:05
• Updated: 11/Dec/14 15:50
• Resolved: 11/Dec/14 15:50

Description

the code :
org.apache.phoenix.util.DateUtil

public static final TimeZone DATE_TIME_ZONE = TimeZone.getTimeZone("GMT");

public static Format getDateParser(String pattern) {
SimpleDateFormat format = new SimpleDateFormat(pattern) {
@Override
public java.util.Date parseObject(String source) throws ParseException

{ java.util.Date date = super.parse(source); return new java.sql.Date(date.getTime()); }

};
format.setTimeZone(DateUtil.DATE_TIME_ZONE);
return format;
}
==================

Every phoenix user will be formated with GMT time zone.

But other's, just like me .the time zone is GMT+8

I think it will be default not be set with
format.setTimeZone(DateUtil.DATE_TIME_ZONE);

when anyone want to set it. add a config in hbase-site.xml.

Issue Links

• duplicates: PHOENIX-1485 Date columns should be displayed without timezone offset