Java TimeZone getExcelSerialDayNumber(Date date, Locale locale, TimeZone timeZone)

Description

get Excel Serial Day Number

License

Open Source License

Declaration

public static double getExcelSerialDayNumber(Date date, Locale locale,
            TimeZone timeZone) 

Method Source Code

//package com.java2s;
/*/*from  w  w  w  .  ja  va 2s  .co  m*/
 * JasperReports - Free Java Reporting Library.
 * Copyright (C) 2001 - 2014 TIBCO Software Inc. All rights reserved.
 * http://www.jaspersoft.com
 *
 * Unless you have purchased a commercial license agreement from Jaspersoft,
 * the following license terms apply:
 *
 * This program is part of JasperReports.
 *
 * JasperReports is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * JasperReports 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 Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with JasperReports. If not, see <http://www.gnu.org/licenses/>.
 */

import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.Locale;
import java.util.TimeZone;

public class Main {
    public static final double JULIAN_0000 = 1721424.5;
    public static final double JULIAN_1900 = 2415020.5;

    public static double getExcelSerialDayNumber(Date date, Locale locale,
            TimeZone timeZone) {
        GregorianCalendar calendar = new GregorianCalendar(timeZone, locale);
        calendar.setTime(date);

        int year = calendar.get(Calendar.YEAR);
        int month = calendar.get(Calendar.MONTH); // starts from 0
        int day = calendar.get(Calendar.DAY_OF_MONTH);
        int hour = calendar.get(Calendar.HOUR_OF_DAY);
        int min = calendar.get(Calendar.MINUTE);
        int sec = calendar.get(Calendar.SECOND);

        double result = getGregorianToJulianDay(year, month + 1, day)
                + (Math.floor(sec + 60 * (min + 60 * hour) + 0.5) / 86400.0);
        return (result - JULIAN_1900) + 1 + ((result > 2415078.5) ? 1 : 0);
    }

    public static double getGregorianToJulianDay(int year, int month,
            int day) {
        return JULIAN_0000
                + (365 * (year - 1))
                + Math.floor((year - 1) / 4)
                - Math.floor((year - 1) / 100)
                + Math.floor((year - 1) / 400)
                + Math.floor((((367 * month) - 362) / 12)
                        + (month <= 2 ? 0 : (isLeapYear(year) ? -1 : -2))
                        + day);
    }

    public static boolean isLeapYear(int year) {
        return year % 4 == 0 && (year % 100 != 0 || year % 400 == 0);
    }
}

Related

1. getDateAtTimeZone(Date when, TimeZone from, TimeZone to)
2. getDateAttributes(long millisec, TimeZone tz, boolean showNumber)
3. getDateBoxValue(TimeZone zone, Date date)
4. getDateValue(TimeZone zone, Long dateBoxValue, Long timeBoxValue)
5. getDateWithoutTimeZone(Date date)
6. getLocalTime( java.util.TimeZone localTimeZone, java.util.Date timestamp, java.util.TimeZone sourceTimeZone)
7. getTimezoneDate(String stateCode)
8. getTimeZoneOffset(Date d)
9. getTimezoneOffsetInHours(Date date)