如何从java中的命令提示符提示“打开文件窗口”？(how to prompt “open file window” from command prompt in java? [duplicate])

 如果您想在Oracle where子句中完全执行此操作，您可以执行以下操作： 
 
WHERE CHRGDTTM >= ADD_MONTHS(TRUNC(sysdate, 'MM'), -1)
AND CHRGDTTM < TRUNC(sysdate, 'MM')
 
 TRUNC(date)函数截断了提供的日期 - 在这种情况下是系统日期; 默认情况下它会删除时间部分，因此会在今天早上给你午夜，但这会修改MM格式模型的行为，并在当月的第一个月提供午夜。 所以今天TRUNC(SYSDATE, 'MM')为您提供2016-01-26 00:00:00。 您可以将其用作日期范围的上端。 
 
 ADD_MONTHS()函数 ，添加了几个月，-1这里给你2015-12-01 00:00:00。 放在一起，为您提供2015-12-01 00:00:00之前的所有内容，但不包括2016-01-01 00:00:00，这相当于您的BETWEEN范围。 
 
 您还可以使用间隔计算来获取上个月的开头： 
 
WHERE CHRGDTTM >= TRUNC(sysdate, 'MM') - INTERVAL '1' MONTH
AND CHRGDTTM < TRUNC(sysdate, 'MM')
 
 具有相同的效果，并且是安全的，因为你总是会得到计算中的有效日期; 几个月末的日期可能更成问题。 
 
 您可以在文档中阅读有关日期时间/间隔算法的更多信息。 

If you want to do this entirely within the Oracle where clause you can do:
 
WHERE CHRGDTTM >= ADD_MONTHS(TRUNC(sysdate, 'MM'), -1)
AND CHRGDTTM < TRUNC(sysdate, 'MM')
 
The TRUNC(date) function truncates the supplied date - the system date in this case; by default it removes the time part so gives you midnight this morning, but this modified that behaviour with the MM format model, and gives you midnight on the first of the current month. So today TRUNC(SYSDATE, 'MM') gives you 2016-01-26 00:00:00. You can use that as it is for the upper end of your date range.
 
The ADD_MONTHS() function, well, adds a number of months, -1 here to give you 2015-12-01 00:00:00 instead. Put together that gives you everything from 2015-12-01 00:00:00 up to, but no including, 2016-01-01 00:00:00, which is equivalent to your BETWEEN range.
 
You could also use an interval calculation to get the start of the previous month: 
 
WHERE CHRGDTTM >= TRUNC(sysdate, 'MM') - INTERVAL '1' MONTH
AND CHRGDTTM < TRUNC(sysdate, 'MM')
 
which has the same effect, and is safe as you're always going to end up with a valid date from the calculation; dates at the ends of months can be more problematic.
 
You can read more about datetime/interval arithmetic in the documentation.