Java SQL Time From toDatetime(long value)

Description

to Datetime

License

Apache License

Declaration

public static java.sql.Timestamp toDatetime(long value) 

Method Source Code

//package com.java2s;
/**/*w ww . j  av  a  2 s  . c  om*/
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You 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.
 */

import java.sql.Timestamp;
import java.util.Calendar;

public class Main {
    public static java.sql.Timestamp toDatetime(long value) {
        final int sec = (int) (value % 100);
        value /= 100;
        final int min = (int) (value % 100);
        value /= 100;
        final int hour = (int) (value % 100);
        value /= 100;
        final int day = (int) (value % 100);
        value /= 100;
        final int mon = (int) (value % 100);
        final int year = (int) (value / 100);
        final Calendar c = Calendar.getInstance();
        c.set(year, mon - 1, day, hour, min, sec);
        return new Timestamp(c.getTime().getTime());
    }
}

Related

1. getDateTimeString(String format)
2. getDateTimeStringFromCalendar(Calendar calendar)
3. getDateTimeTypeString(Connection conn)
4. getDateTimeTypeString(Connection conn)
5. toDateTime(final java.util.Date d)
6. toDateTimeString(java.util.Date inDate)
7. toSQLTime(final LocalTime lt)
8. toSqlTime(long date)
9. toTime(Date value)