Retrieving Timestamp data from DB using Mysql

Question

I have a Java MVC model.Which has timestamp as one of the DB value which is already inserted into DB.I have declared the data type as Timestamp in DB,Now the problem is If i try to retrieve it is showing null values & can not be represented as java.sql.Timestamp

Statement :

pstmt = con.prepareStatement("SELECT timestamp, FROM nid where id=?");
pstmt.setDouble(1, nidev);
            rs = pstmt.executeQuery(); 
            if(rs.next())
            {  
                timeBean.setHbtimestamp(rs.getTimestamp("timestamp"));

            }

Bean Class:

private Timestamp hbtimestamp;

public Timestamp getHbtimestamp() {
    return hbtimestamp;
}
public void setHbtimestamp(Timestamp hbtimestamp) {
    this.hbtimestamp = hbtimestamp;
}

MyDB value is successfully inserted :2015-05-14 15:45:57

output: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp

As well first print the value of rs.getTimestamp("timestamp") before setting it. — prashant thakre
– prashant thakre, Commented May 14, 2015 at 12:56
This is what i am getting Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp — Ramesh
– Ramesh, Commented May 14, 2015 at 13:05
Go to hibernate configuration file add attribute showsql true. Execute code again and it will print sql equivilaent query in conolse the same query execute in sql prompt and check the result.It looks like your query itself not returning anything. — prashant thakre
– prashant thakre, Commented May 14, 2015 at 14:09

Community · Accepted Answer · 2017-05-23 10:24:09Z

1

Set in your MySQL

zeroDateTimeBehavior=convertToNull

Then empty time stamp values will be interpreted as NULLs

Well explained here

edited May 23, 2017 at 10:24

CommunityBot

11 silver badge

answered May 14, 2015 at 13:09

StanislavL

57.5k9 gold badges75 silver badges100 bronze badges

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

4 Comments

Ramesh Over a year ago

Sorry i did not get ,Can you please help me

Ramesh Over a year ago

I did this one added into URL & it is converted to null

Ramesh Over a year ago

jdbc:mysql://localhost:3306/acc_dev_db?zeroDateTimeBehavior=convertToNull

Ramesh Over a year ago

No i am getting Null value,I want the timestamp in DB

Collectives™ on Stack Overflow

Retrieving Timestamp data from DB using Mysql

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related