retreaving timestamp record from databse

Question

how to access timestamp object in resultset. i use this code

String displayzone  =Rs.getTimestamp("TIME_ZONE").toString();

it will be error....

Answer 1

You should check that the contents of the field TIME_ZONE are truly a timestamp. Perhaps the field is not defined as a timestamp. Perhaps it contains a representation of the time zone, such as PDT or IST, or even -0700 In such a case, the call to getTimestamp() will recognize that it is not a timestamp and will throw an error.