All Forums Connectivity
karteeek.majety 1 post Joined 05/15
09 Sep 2015
Retrieving TimeZone from TimeStamp

I am using Teradata JDBC Driver (
I have created a column for a table with data type TIMESTAMP WITH TIME ZONE ( It has the time with HH:MM:SS(upto 6 digits) + Timezone
When I fetch the resulset through JDBC I am missing the precision of seconds and also the timezone.
I have tried with rs.getObject(),rs.getTimeStamp() but still I am not able retrieve the exact TIMSTAMP WITH TIMEZONE
Data in table:2015-07-23 14:05:01.073000+00:00
 Expected :2015-07-23 14:05:01.073000+00:00
 ActualResut :002015-07-23 14:05:01.073
Could someone help me in getting the exact column as it is from the Database?

tomnolan 594 posts Joined 01/08
09 Sep 2015

The Teradata JDBC Driver User Guide has a very detailed section on working with Timestamps and Time Zones. In particular, please read the subsection titled "Receiving DATE, TIME, and TIMESTAMP Values".
To summarize, you need to call the getTimestamp method with a Calendar argument. The Teradata JDBC Driver will set the Calendar argument's TimeZone object to the value of the Timestamp's time zone.

You must sign in to leave a comment.