Java SQL Time Create timeToInternal(java.sql.Time time)

Description

Converts the Java type used for UDF parameters of SQL TIME type ( java.sql.Time ) to internal representation (int).

License

Apache License

Declaration

public static int timeToInternal(java.sql.Time time) 

Method Source Code

//package com.java2s;
/*/*from   w ww. j a v  a2s  . com*/
 * 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.util.TimeZone;

public class Main {
    /**
     * The number of milliseconds in a day.
     *
     * <p>This is the modulo 'mask' used when converting
     * TIMESTAMP values to DATE and TIME values.
     */
    private static final long MILLIS_PER_DAY = 86400000;
    /** The UTC time zone. */
    public static final TimeZone UTC_ZONE = TimeZone.getTimeZone("UTC");

    /** Converts the Java type used for UDF parameters of SQL TIME type
     * ({@link java.sql.Time}) to internal representation (int).
     *
     * <p>Converse of {@link #internalToTime(int)}. */
    public static int timeToInternal(java.sql.Time time) {
        return timeToInternal(time, UTC_ZONE);
    }

    /** Converts the Java type used for UDF parameters of SQL TIME type
     * ({@link java.sql.Time}) to internal representation (int).
     *
     * <p>Converse of {@link #internalToTime(int)}. */
    public static int timeToInternal(java.sql.Time time, TimeZone tz) {
        long ts = time.getTime() + tz.getOffset(time.getTime());
        return (int) (ts % MILLIS_PER_DAY);
    }
}

Related

1. sumTimes(String[] timeStrings, DateFormat df)
2. time2Double(java.sql.Time time)
3. time2String(final java.sql.Time value)
4. timeToBytes(Time t)
5. timeToCalendar(Time input)
6. timeToLong(Object timeObj)
7. timeToString(java.sql.Time a_Time, String aS_Format)
8. timeToString(Time t)
9. timeToString(Time time)