Java Timestamp endOfMonth(java.sql.Timestamp dd)

Description

covert Timestamp to end of day in month, 23:59:59 leaving date part untouched

License

Open Source License

Parameter

Parameter	Description
dd	a date to use

Return

end of last day of last month

Declaration

public static java.sql.Timestamp endOfMonth(java.sql.Timestamp dd) 

Method Source Code

//package com.java2s;
/*//w w  w  . j  a  va  2s .  co m
 * @(#)TimeUtils.java   0.51 1999/07/14
 *
 * Copyright (c) 2004, Pat Farrell, All rights reserved.
 * based on work Copyright (c) 2000, OneBigCD, Inc.  All rights reserved.
 * Copyright (C) 2011 Patrick Farrell   All Rights reserved.
 * 
 * Licensed 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. * Licensed 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.
 * 
 * It is abstract because all functions are static
 */

import java.util.Calendar;

import java.util.GregorianCalendar;

import java.util.TimeZone;

public class Main {
    /** constant for UTC */
    public static final TimeZone utcTZ = TimeZone.getTimeZone("UTC");

    /**
     * covert Timestamp to end of day in month, 23:59:59 leaving date part
     * untouched
     * @param dd a date to use
     * @return  end of last day of last month
     */
    public static java.sql.Timestamp endOfMonth(java.sql.Timestamp dd) {
        Calendar cal = GregorianCalendar.getInstance(utcTZ);
        cal.setTime(dd);
        cal = endOfMonth(cal);
        java.sql.Timestamp rval = new java.sql.Timestamp(cal.getTime().getTime());
        return rval;
    }

    /**
     * covert Timestamp to end of day in month, 23:59:59 leaving date part
     * untouched
     * @param dd a date to use
     * @return  end of last day of last month
     */
    public static Calendar endOfMonth(Calendar dd) {
        Calendar cal = (Calendar) dd.clone();
        int maxDate = cal.getActualMaximum(Calendar.DAY_OF_MONTH);
        cal.set(Calendar.DAY_OF_MONTH, maxDate);
        cal.set(Calendar.HOUR_OF_DAY, 23);
        cal.set(Calendar.MINUTE, 59);
        cal.set(Calendar.SECOND, 59);
        return cal;
    }
}

Related

1. delta_hours(Timestamp startdate, Timestamp enddate)
2. differDayByNow(Timestamp timestamp)
3. doubleToTimestamp(double f)
4. durationBetween(Timestamp startedAt, Timestamp completedAt)
5. encodeTimestamp(Timestamp timestamp)
6. extractDateSystemTimeStamp()
7. floorAsDate(Timestamp time)
8. fromDate(Timestamp timestamp)
9. fromTimestamp(Timestamp timestamp)