Hi Thanaphol,

Could you elaborate on how you're debugging this issue? The reason I ask is that the JDBC Timestamp class does some of its own formatting when you query it as a string (it formats the string to a timestamp in the local timezone).

The general rules are as follows:
* the bulk loader interprets date/time/timestamp strings as being in GMT
* Phoenix stores only the long value of the date/time/timestamp internally
* JDBC date/time/timestamp values are instantiated based on the long value when you query them

In other words, Phoenix treats everything internally as being in GMT. However, if you run a query on a timestamp column in a non-GMT locale and display the timestamps as strings, the string will be the local timezone representation of the GMT timestamp -- the internal long value will be the same, but the string representation will be different than the file that you imported.

- Gabriel

On Tue, Feb 10, 2015 at 11:14 AM, Thanaphol Prasitphaithoon <thanaphol.p@mindterra.com> wrote:
Hi All
 I use phoenix 4.2.2 and I bulk load csv file to phoenix. When I check records on timestamp column, records in table are different from csv. It like phoenix convert GMT time zone to ICT Timezone(ICT is my timezone). GMT is default time zone on phoenix. 

Does Phoenix has parameter to specific default timezone or other solution to suggest me to do.

Best Regards,

Thanaphol Prasitphaithoon
Information Security Engineer
Service Department
Mindterra Company Limited
Tel: (+66) 2530 2062-4
Fax: (+66) 2530 2177
Mobile: (+66) 84-022-0683
E-mail: thanaphol.p@mindterra.com
Website: http://www.mindterra.com
Interact Mindterra via Facebook and Twitter