if (param1 instanceof Number) {
int scale;
try {
scale = getInteger(param2);
} catch (ParseException e) {
throw new ParseException(PARAM_EXCEPTION);
}
if (scale < 0) {
return ZERO;
}
if (param1 instanceof BigDecimal) { // BigInteger is not supported
return ((BigDecimal)param1).setScale(scale, BigDecimal.ROUND_DOWN);
}
else if (param1 instanceof Double || param1 instanceof Float) {
double d = ((Number)param1).doubleValue();
long mult = 1;
for (int i = 0; i < scale; i++) {
mult *= 10;
}
long l = (long)d*mult;
return ((double)l)/mult;
} else {
return param1; // Long, Integer, Short, Byte
}
}
else if (param1 instanceof java.util.Date) {
if (param2 instanceof String) {
String s = (String)param2;
java.util.Date d = (java.util.Date)param1;
cal.setTimeInMillis(d.getTime());
if (s.equalsIgnoreCase("CC") || s.equalsIgnoreCase("SCC")) {
if (d instanceof java.sql.Time) {
throw new ParseException(TIME_EXCEPTION);
}
int year = cal.get(YEAR);
cal.clear();
cal.set((year/100)*100, 0, 1);
return new Timestamp(cal.getTimeInMillis());
}
else if (s.equalsIgnoreCase("SYYYY") || s.equalsIgnoreCase("YYYY") || s.equalsIgnoreCase("YYY") ||
s.equalsIgnoreCase("Y") || s.equalsIgnoreCase("YEAR") || s.equalsIgnoreCase("SYEAR")) {
if (d instanceof java.sql.Time) {
throw new ParseException(TIME_EXCEPTION);
}
int year = cal.get(YEAR);
cal.clear();
cal.set(year, 0, 1);
return new Timestamp(cal.getTimeInMillis());
}
else if (s.equalsIgnoreCase("IYYY") || s.equalsIgnoreCase("IY") || s.equalsIgnoreCase("I")) {
throw new ParseException(NOT_IMPLIMENTED_EXCEPTION);
}
else if (s.equalsIgnoreCase("Q")) {
if (d instanceof java.sql.Time) {
throw new ParseException(TIME_EXCEPTION);
}
int year = cal.get(YEAR);
int month = cal.get(MONTH);
cal.clear();
cal.set(year, (month/3)*3, 1);
return new Timestamp(cal.getTimeInMillis());
}
else if (s.equalsIgnoreCase("MONTH") || s.equalsIgnoreCase("MON") ||
s.equalsIgnoreCase("MM") || s.equalsIgnoreCase("RM")) {
if (d instanceof java.sql.Time) {
throw new ParseException(TIME_EXCEPTION);
}
int year = cal.get(YEAR);
int month = cal.get(MONTH);
cal.clear();
cal.set(year, month, 1);
return new Timestamp(cal.getTimeInMillis());
}
else if (s.equalsIgnoreCase("WW")) {
if (d instanceof java.sql.Time) {
throw new ParseException(TIME_EXCEPTION);
}
int year = cal.get(YEAR);
int month = cal.get(MONTH);
int day = cal.get(DAY_OF_MONTH);
int dw = cal.get(DAY_OF_WEEK);
cal.clear();
cal.set(year, 0, 1);
int dayOfWeek = cal.get(DAY_OF_WEEK);
cal.set(year, month, day - (dw<dayOfWeek ? 7-(dayOfWeek-dw) : dw-dayOfWeek));
return new Timestamp(cal.getTimeInMillis());
}
else if (s.equalsIgnoreCase("W")) {
if (d instanceof java.sql.Time) {
throw new ParseException(TIME_EXCEPTION);
}
int year = cal.get(YEAR);
int month = cal.get(MONTH);
int day = cal.get(DAY_OF_MONTH);
int dw = cal.get(DAY_OF_WEEK);
cal.clear();
cal.set(year, month, 1);
int dayOfWeek = cal.get(DAY_OF_WEEK);
cal.set(year, month, day - (dw<dayOfWeek ? 7-(dayOfWeek-dw) : dw-dayOfWeek));
return new Timestamp(cal.getTimeInMillis());
}
else if (s.equalsIgnoreCase("IW")) {
throw new ParseException(NOT_IMPLIMENTED_EXCEPTION);
}
else if (s.equalsIgnoreCase("DAY") || s.equalsIgnoreCase("DY") || s.equalsIgnoreCase("D")) {
if (d instanceof java.sql.Time) {
throw new ParseException(TIME_EXCEPTION);
}
int year = cal.get(YEAR);
int month = cal.get(MONTH);
int day = cal.get(DAY_OF_MONTH);
int dw = cal.get(DAY_OF_WEEK);
cal.clear();
cal.set(year, month, day-(dw-cal.getFirstDayOfWeek()));
return new Timestamp(cal.getTimeInMillis());
}
else if (s.equalsIgnoreCase("HH") || s.equalsIgnoreCase("HH12") || s.equalsIgnoreCase("HH24")) {
if (d instanceof java.sql.Date) {
throw new ParseException(DATE_EXCEPTION);
}
cal.set(MINUTE, 0);
cal.set(SECOND, 0);
cal.set(MILLISECOND, 0);
return new Timestamp(cal.getTimeInMillis());
}
else if (s.equalsIgnoreCase("MI")) {
if (d instanceof java.sql.Date) {
throw new ParseException(DATE_EXCEPTION);
}
cal.set(SECOND, 0);
cal.set(MILLISECOND, 0);
return new Timestamp(cal.getTimeInMillis());
} else {
throw new ParseException(FORMAT_EXCEPTION);
}
}
}
throw new ParseException(WRONG_TYPE+" trunc("+param1.getClass()+","+param2.getClass()+")");
}