How to retrieve mysql timestamp column from java.sql.timestamp

Question

I have a timestamp column in a mysql table. I am unable to retrieve this value from java.sql.ResultSet using getTimestamp(String label).

ResultSet rs = preparedStatement.getResultSet();
        rList = new ArrayList<String>();
        while (rs.next() != false){
            rList.add(rs.getString("urlstring"));
            if (rs.getTimestamp("mytimestamp") == null) {
                rList.add("null");
            } else {
                rList.add(rs.getTimestamp("mytimestamp").toString());
            }
        }

I can confirm that there are results in the resultset. When I omit the statements which attempt to retrieve the timestamp from the resultset, the list populates as expected, however, when I run the above code, there is no error but the list is empty.

rather than getting the value by name, maybe try by index. Have you run this through a debugger? — Scary Wombat
– Scary Wombat, Commented May 24, 2013 at 8:09

Community · Accepted Answer · 2017-05-23 12:14:03Z

1

getTimestamp() works on DateTime MySQL columns.

See Handling MySQL datetimes and timestamps in Java in order to resolve your question :)

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered May 24, 2013 at 8:14

caligari

2,12821 silver badges25 bronze badges

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

Comments

Joop Eggen · Accepted Answer · 2013-05-24 08:08:28Z

0

Did you do

ResultSet rs = preparedStatement.exequteQuery();

You could try (if this were the first while (rs.next())).

if (rs.first()) {
    do {
        rList.add(rs.getString("urlstring"));
        if (rs.getTimestamp("mytimestamp") == null) {
            rList.add("null");
        } else {
            rList.add(rs.getTimestamp("mytimestamp").toString());
        }
    } while (rs.next());
}

answered May 24, 2013 at 8:08

Joop Eggen

110k8 gold badges89 silver badges142 bronze badges

Collectives™ on Stack Overflow

How to retrieve mysql timestamp column from java.sql.timestamp

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related