In accordance with mysql function from_days - Java java.sql

Java examples for java.sql:MySQL

  1. HOME
  2. Java
  3. java.sql
  4. MySQL

Description

In accordance with mysql function from_days

Demo Code


//package com.java2s;
import java.util.Calendar;
import java.util.Date;

public class Main {
    private static final int BASE_YEAR = 1970;
    private static final int BASE_MONTH = Calendar.JANUARY;
    private static final int BASE_DAY = 1;
    /**/*from w  ww .  ja va  2s . com*/
     * days elapsed since 1970-01-01, mysql to_days('1970-01-01')
     */
    private static final int BASE_DAYS_OFFSET = 719528;

    /**
     * In accordance with mysql function from_days
     *
     * @param days
     * @return
     */
    public static Date fromDays(int days) {
        if (days < BASE_DAYS_OFFSET) {
            throw new IllegalArgumentException("days cannot be less than "
                    + BASE_DAYS_OFFSET + " (mysql to_days('1970-01-01'))");
        }

        Calendar cal = Calendar.getInstance();
        cal.set(BASE_YEAR, BASE_MONTH, BASE_DAY, 0, 0, 0);
        cal.set(Calendar.MILLISECOND, 0);

        cal.add(Calendar.DAY_OF_MONTH, days - BASE_DAYS_OFFSET);

        return cal.getTime();
    }
}

Related Tutorials