Java SQL Date Convert dateToInternal(java.sql.Date date)

Description

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

License

Apache License

Declaration

public static int dateToInternal(java.sql.Date date) 

Method Source Code

//package com.java2s;
/*/*from w w w .  jav  a  2 s .co  m*/
 * 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 DATE type
     * ({@link java.sql.Date}) to internal representation (int).
     *
     * <p>Converse of {@link #internalToDate(int)}. */
    public static int dateToInternal(java.sql.Date date) {
        return dateToInternal(date, UTC_ZONE);
    }

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

Related

1. dateToBeginOfDay(Date data)
2. dateToBytes(Date d)
3. dateToCalendar(Date input)
4. dateToLong(Date date)
5. dateToSql(Date dat)
6. dateToSqlDate(Date date)
7. dateToSqlDate(Date date)