Java date question using oracle10g

Question

I am trying to decode this little peice of java code (using an oracle10g database) from a left over program i am remaking in VB.net. Say i chose on the datepicker 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))

Where the +1's are, is it adding a month (02/02/11) or day (01/03/11)? And for the -1's, is it subtracting a month (12/02/10) or a day (01/01/11)?

David

Whatever does pay the bills is good enough, huh

Boris Pavlović
– Boris Pavlović

2011-01-27 14:14:49 +00:00
Commented Jan 27, 2011 at 14:14 — Boris Pavlović
– Boris Pavlović, Commented Jan 27, 2011 at 14:14

Boris Pavlović · Accepted Answer · 2011-01-27 13:34:49Z

2

It's subtracting/adding a day.

Try running:

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

it should return:

09/30/09

answered Jan 27, 2011 at 13:34

Boris Pavlović

64.9k29 gold badges127 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

StealthRT Over a year ago

If the database has '11/2/2009 3:00:20 PM' format how would i covert that to what i am trying to toDate? I've already tried where to_date(BEGIN_DATE, 'MM/DD/YY') but that gives an error.

Boris Pavlović Over a year ago

Convert the comment to a question and you'll earn even more points :)

StealthRT Over a year ago

I just got a "Cleanup" badge for that :o)

Collectives™ on Stack Overflow

Java date question using oracle10g

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related