Question

I have a vector that is created by retrieving data from a database It is filled with information that includes Date, Time, Volume ect... I need to create a spreadsheet from these values however I need to Remove values where the date is on a weekend(and specific holidays if possible) but more importantly the weekends If anyone knows of a function that is able to do this that would be great Thanks.

Answer 1

如果您在Java中有一个Date对象，那么您可以使用日历对象执行此操作。

获取日历的一个实例，然后调用Get（Calendar.DAY_of_WEEK）。如果值为Saturday或Sunday，请将其从集合中删除。

Calendar calendar = Calendar.getInstance();
calendar.setTime(yourDateObject);
int dayOfWeek = calendar.get(Calendar.DAY_OF_WEEK);
if(dayOfWeek == Calendar.SATURDAY || dayOfWeek == Calendar.SUNDAY) {
    //remove this Date
}

Answer 2

如果您有日期的时间戳，则可以使用GregorianCalendar。

http://download.oracle.com/javase/6/docs/api/java/util/Calendar.html#setFirstDayOfWeek（int）

GregorianCalendar cal = new GregorianCalendar();
cal.setTime(yourDate);
cal.get(Calendar.DAY_OF_WEEK) // Would be Calendar.SUNDAY or something;

友情链接