Question

我正试图从VB.net方案一转而形成的左边,把java法典的这个小 pe(使用一个矿石10g数据库)脱下来。 Sayi在日期被cker客选择 01/02/11:

AND (due_date between (to_date( " + dateChooserCombo1.getSelectedPeriodSet().toString() 
+ " ,  MM/DD/YY ) - 1) 
AND (to_date( " + dateChooserCombo1.getSelectedPeriodSet().toString() + " ,  MM/DD/YY ) + 1) 
OR " + "begin_date between (to_date( " + dateChooserCombo1.getSelectedPeriodSet().toString() + " ,  MM/DD/YY ) - 1) 
AND (to_date( " + dateChooserCombo1.getSelectedPeriodSet().toString() + " ,  MM/DD/YY ) + 1))

加上1个月(02/02/11)还是一天(01/03/11) 而对于1至1分,它是否分了一个月(12/02/10)或一天(01/01/11)?

David

Answer 1

每天拖拉/上台。

履历:

select toDate( 10/01/09 ,  MM/DD/YY ) - 1 from whatever_table

它应当返回:

09/30/09

友情链接