http://jdbi.org/jdbi3-jodatime2/: Jdbi is designed to provide convenient tabular data access in Java(tm). It uses the Java collections framework for query results, provides a convenient means of externalizing sql statements, and provides named parameter support for any database being used. 
/*
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.jdbi.v3.jodatime2;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;

import org.jdbi.v3.core.mapper.ColumnMapper;
import org.jdbi.v3.core.statement.StatementContext;
import org.joda.time.DateTime;


Map a Timestamp to a DateTime. 
/**
 * Map a {@link Timestamp} to a {@link DateTime}.
 */
public class DateTimeMapper implements ColumnMapper<DateTime> {
    @Override
    public DateTime map(ResultSet r, int columnNumber, StatementContext ctx) throws SQLException {
        Timestamp ts = r.getTimestamp(columnNumber);
        return ts == null ? null : new DateTime(ts.getTime());
    }
}