MYSQL ADDTIME method gives exception : Java.lang.string cannot be cast to timestamp

Question

I have a query which fetches data and time from db, I am using addtime method of mysql to concat the two columns and return a single column.

IN mysql 5.5 the same query gave the result with return type as timestamp in java. I upgraded the db to 5.6 and now the result is in string and so the code gives exception that "String cannot be cast to Timestamp". My Query is

SELECT offerId , 
       status,  
       ADDTIME(effective_date_end, effective_time_end) asn endDateTime from offer

Data type of effective_date_end is date and that of effective_time_end is time.

After getting the result i am doing this in my java code.

java.sql.Timestamp)offerDetailMap.get("endDateTime")

This line now gives error.

Is there any way to get the two fields merged and return a time stamp in mysql 5.6?

Timestamp offerEndDate = (java.sql.Timestamp)offerDetailMap.get("endDateTime") — Shabin Hashim
– Shabin Hashim, Commented Feb 21, 2014 at 13:45

Community · Accepted Answer · 2017-05-23 12:28:43Z

1

As much as I would love to claim credit for an answer, I believe you might be looking for the answer given here: Convert Java String to sql.Timestamp

edited May 23, 2017 at 12:28

CommunityBot

11 silver badge

answered Feb 21, 2014 at 13:48

Mourdos

2233 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shabin Hashim Over a year ago

Thats working. But i want to retive the column with data type as Timestamp instead of string. This was working in 5.5.

Collectives™ on Stack Overflow

MYSQL ADDTIME method gives exception : Java.lang.string cannot be cast to timestamp

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related