[
https://issues.apache.org/jira/browse/PHOENIX-997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14008586#comment-14008586
]
jay wong commented on PHOENIX-997:
----------------------------------
[~gabriel.reid]
The case is for upsert a row which has a column DataType is Timestamp.
the value input such as 2014-05-01 10:00:00 format is yyyy-MM-dd HH:mm:ss
But as my client side server or my own macbook pro. the timezone is GMT+8
So when I execute a query . The result I got is 2014-05-01 18:00:00
> Timestamp date type default format with GMT time zone
> -----------------------------------------------------
>
> Key: PHOENIX-997
> URL: https://issues.apache.org/jira/browse/PHOENIX-997
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 3.0.0
> Reporter: jay wong
> Fix For: 3.1
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
