Java Timestamp Field getSqlTimestampFromMicrosSinceEpoch( long timestamp)

Description

get Sql Timestamp From Micros Since Epoch

License

Open Source License

Declaration

public static java.sql.Timestamp getSqlTimestampFromMicrosSinceEpoch(
            long timestamp) 

Method Source Code

//package com.java2s;
/* This file is part of VoltDB.
 * Copyright (C) 2008-2015 VoltDB Inc.// ww  w .  j  ava  2  s .c o  m
 *
 * 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.
 *
 * 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 VoltDB.  If not, see <http://www.gnu.org/licenses/>.
 */

public class Main {
    public static java.sql.Timestamp getSqlTimestampFromMicrosSinceEpoch(
            long timestamp) {
        java.sql.Timestamp result;

        // The lower 6 digits of the microsecond timestamp (including the "double-counted" millisecond digits)
        // must be scaled up to get the 9-digit (rounded) nanosecond value.
        if (timestamp >= 0) {
            result = new java.sql.Timestamp(timestamp / 1000);
            result.setNanos(((int) (timestamp % 1000000)) * 1000);
        } else {
            result = new java.sql.Timestamp(
                    (timestamp / 1000000 - 1) * 1000);

            int remaining = (int) (timestamp % 1000000);
            result.setNanos((remaining + 1000000) * 1000);
        }

        return result;
    }
}

Related

1. getSeconds(Timestamp timeStamp)
2. getServerToUserDateString(TimeZone timeZone, int dateFormat, java.sql.Timestamp date)
3. getSqlTimeStamp()
4. getSqlTimeStamp(java.util.Date date)
5. getSQLTimeStampForDate(Date date)
6. getSqlTimestampFromShortDate(String date)
7. getStamp(Timestamp timestamp)
8. getStringToTimestamp(String str)
9. getstrTimestamp(String datetime)