Java Timestamp TimestampNow()

Description

return the current system time as an SQL Timestamp.

License

Open Source License

Return

the current time as a Timestamp

Declaration

public static Timestamp TimestampNow() 

Method Source Code

//package com.java2s;
/*//from   w  w w .  j av a 2s . c  o  m
 * Copyright 2011, United States Geological Survey or
 * third-party contributors as indicated by the @author tags.
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * 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 General Public License for more details.
 *
 * You should have received a copy of the GNU 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.sql.Time;
import java.sql.Timestamp;

public class Main {
    /** return the current system time as an SQL Timestamp. 
    *@return the current time as a Timestamp*/
    public static Timestamp TimestampNow() {
        java.util.Date now = new java.util.Date();
        return new Timestamp(now.getTime());
    }

    /** get a Time from ResultSet rs with name 'column' 
       *@param rs The ResultSet to get this column from
    *@param column The  column to get
    *@return The target column value
    *@throws SQLException if column does not exist or other SQL error
    */
    public static Time getTime(ResultSet rs, String column) throws SQLException {
        Time i = rs.getTime(column);
        if (rs.wasNull())
            i = new Time(0);
        return i;
    }

    /** get a Time from ResultSet rs with name 'column' 
       *@param rs The ResultSet to get this column from
    *@param column The  column to get
    *@return The target column value
    *@throws SQLException if column does not exist or other SQL error
    */
    public static Time getTime(ResultSet rs, int column) throws SQLException {
        Time i = rs.getTime(column);
        if (rs.wasNull())
            i = new Time(0);
        return i;
    }
}

Related

1. timestampInMs()
2. timestampIntToTimestamp(long timestampInt)
3. timestampIsEquals(Timestamp timestamp1, Timestamp timestamp2)
4. TimeStampMonthDayYear(Timestamp timestamp)
5. timestampNow()
6. timestampOf(final ZonedDateTime time)
7. timestampPlusDay(java.sql.Timestamp ts, int iDayPlus)
8. timestampPlusDay2DDMMYYYY(java.sql.Timestamp ts, int iDayPlus)
9. trunc(Timestamp dayTime, String trunc)