Results 1 to 3 of 3
Jun 12, 2004, 02:18 #1
Oracle: What's wrong with this statment again? (between 2 dates)
Sorry for bothering you with my endless questions...
I have a table named: pr_official_vacation and I want to select any current employee on vacation...
I have the fallowing record with the emplyee ID: 4815:
SELECT COUNT(*) AS total5 FROM pr_official_vacation WHERE EMPID = '4815' AND START_DATE >= to_date('06/04/04' ,'mm/dd/yy') AND END_DATE <= to_date('06/04/04' ,'mm/dd/yy')
TOTAL5 is 0 always
Please tell me what's wrong?
Thank you...Why It Doesn't Work?!
Jun 12, 2004, 02:33 #2
Never mind... problem solved.
I am sorry for writing it before I revise the code well... I have a project in a forign country and the flight date is very soon!Why It Doesn't Work?!
Jun 13, 2004, 05:05 #3
- Join Date
- Jul 2003
- 1 Post(s)
- 0 Thread(s)
I take it you spotted that the end date couldn't be less than or equal to the start date, and still pick up someone with an end date that was greater than the start date
i.e. more than one day off, that one day being your 06/04/04Dr John