Java SQL Time roundDatetimeValue(Object value)

Description

Utility method for a datetime value

License

Open Source License

Parameter

Parameter	Description
value	a parameter

Declaration

public static Object roundDatetimeValue(Object value) 

Method Source Code

//package com.java2s;
//License from project: Open Source License 

import java.sql.Timestamp;
import java.util.Calendar;

public class Main {
    /**// w w  w .  java  2  s . co m
     * Utility method for a datetime value
     * 
     * @param value
     * @return
     */
    public static Object roundDatetimeValue(Object value) {
        if (value == null)
            return null;
        Timestamp ts = value instanceof Timestamp ? (Timestamp) value
                : new Timestamp(((Calendar) value).getTimeInMillis());
        int millis = ts.getNanos() / 1000000;
        int lastDigit = (int) (millis % 10);
        switch (lastDigit) {
        // 0, 1 -> 0
        case 1:
            ts.setNanos((millis - 1) * 1000000);
            break;

        // 2, 3, 4 -> 3
        case 2:
            ts.setNanos((millis + 1) * 1000000);
            break;
        case 4:
            ts.setNanos((millis - 1) * 1000000);
            break;

        // 5, 6, 7, 8 -> 7
        case 5:
            ts.setNanos((millis + 2) * 1000000);
            break;
        case 6:
            ts.setNanos((millis + 1) * 1000000);
            break;
        case 8:
            ts.setNanos((millis - 1) * 1000000);
            break;

        // 9 -> 0 with overflow
        case 9:
            ts.setNanos(0);
            ts.setTime(ts.getTime() + millis + 1);
            break;

        // default, i.e. 0, 3, 7 -> 0, 3, 7
        // don't change the millis but make sure that any
        // sub-millisecond digits are zeroed out
        default:
            ts.setNanos((millis) * 1000000);
        }
        if (value instanceof Calendar) {
            ((Calendar) value).setTimeInMillis(ts.getTime());
            ((Calendar) value).getTimeInMillis();
            return value;
        }
        return ts;
    }
}

Related

1. parseDate(String datetime, String format)
2. readTime(ByteBuffer buffer)
3. removeTimefromDate(Date inputDate)
4. resetDayTime(Time date)
5. resetNetworkTimeout(Connection rawConnection, Executor executor, int oldTimeout)
6. roundSmallDateTimeValue(Object value)
7. saveGameScores(String gameName, String player1, String player2, String player3, String player4, short score1, short score2, short score3, short score4, java.util.Date startTime)
8. serialize(LocalDateTime date)
9. serializeSqlTime(Time time)