records between 2 dates

Posted on 16th Feb 2014 07:03 pm by admin

Hello all,

I have a date tracked table which contains effective_start_date and effective_end_date fields where we have the start date and end dates of an employee. Each employee can have multiple records with different start and end date.

Now, how can i find his records which are active in the dates between '01-JAN-2007' AND '01-JAN-2008'

Thanks

Your Answer:

Login to answer

Other forums

Is there something wrong?
Hi all,

Just a quick question... can someone look at this code and see if something is wrong?

get font info from a font file
hello,

Does anyone know how to get font info from a font file ... using php of course !
<

Rss feed question
Hi

My blog and my website are different. Am i able to take my rss feed
from my blog and p

php not working written for consumption of slots
1. Here is the function where i will be allowed to consume the slot booked by me.

2. Here i c

Pass sql into pl/sql and create RMAN duplicate script.
Hi,

I'm new to pl/sql and I'm trying to write a script that will generate some RMAN comma

Oracle11g Patch issue
Hi all,

I'm getting the following error while installing Oracle11g Patch 11.1.0.7.0 on IBM-AI

MII Netweaver Server stopped due to CPIC connection Problem
Dear Experts,
We have SAP XMII 12.0 setup running on Netweaver 2004s,7.0, Java Stack only.

PHP Session Issue
I'm having an issue with one section on my website dealing with sessions. Now I know that myself and

JSON SORT WITH PHP
I have two products that I want to sort by say "Id:17, value: xxx" using php
The page w

Request.UrlReferrer
I need to make it so that a page can only be loaded when a button is clicked on a specific page. I d