Java SQL Date Get getDateFromLong(ResultSet resultSet, int index)

Description

Gets a Date value from a Long value from a current result set.

License

Open Source License

Parameter

Parameter	Description
resultSet	a parameter
index	a parameter

Exception

Parameter	Description
SQLException	an exception

Return

the Date value if it exists a long value, null otherwise.

Declaration

public static Date getDateFromLong(ResultSet resultSet, int index) throws SQLException 

Method Source Code

//package com.java2s;
/**/*from  ww w .  j  a  va  2s .c  om*/
 * Copyright (C) 2000 - 2013 Silverpeas
 *
 * This program is free software: you can redistribute it and/or modify it under the terms of the
 * GNU Affero General Public License as published by the Free Software Foundation, either version 3
 * of the License, or (at your option) any later version.
 *
 * As a special exception to the terms and conditions of version 3.0 of the GPL, you may
 * redistribute this Program in connection with Free/Libre Open Source Software ("FLOSS")
 * applications as described in Silverpeas's FLOSS exception. You should have received a copy of the
 * text describing the FLOSS exception, and it is also available here:
 * "http://www.silverpeas.org/docs/core/legal/floss_exception.html"
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without
 * even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License along with this program.
 * If not, see <http://www.gnu.org/licenses/>.
 */

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

import java.util.*;

public class Main {
    /**
     * Gets a Date value from a Long value from a current result set.
     * @param resultSet
     * @param index
     * @return the Date value if it exists a long value, null otherwise.
     * @throws SQLException
     */
    public static Date getDateFromLong(ResultSet resultSet, int index) throws SQLException {
        Long dateIntoLongFormat = getLong(resultSet, index);
        if (dateIntoLongFormat != null) {
            return new Date(dateIntoLongFormat);
        }
        return null;
    }

    /**
     * Gets a long value from a current result set.
     * @param resultSet
     * @param index
     * @return the long value if it exists, null otherwise.
     * @throws SQLException
     */
    public static Long getLong(ResultSet resultSet, int index) throws SQLException {
        if (resultSet.getObject(index) != null) {
            return resultSet.getLong(index);
        }
        return null;
    }
}

Related

1. getDateByYearAndMonth(int year, int month)
2. getDateDiscrepancy(String startDate, String endDate)
3. getDateEnd(Date date)
4. getDateForStr(String str)
5. getDateFromISODateString(String isoDate)
6. getDateFromResultSet(ResultSet rset, Enum field)
7. getDateFromRTGSDateString(String iobDate)
8. getDateFromTimestamp(Timestamp timestamp)
9. getDateFromYMD(Date ymd)