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

HTML Email rec'd as Source Code
The code does create and send the email successfully. However, the message shows as html code and n

All possible combinations of String in PL/SQL
Hi All,

Could you please explain the logic of getting all possible combinations of String

What's best way to get a user's Word doc converted to simple html and images?
Hi all,

I was just wondering if anybody has any experience of this.
Basically, I'm buildin

php slowing my site?
Hi all,

I think that one of the reasons that my site doesn't work fast is that the code is ve

an interesting question
Greetings folks, got to ask an interesting question...

let say
i have created a function s

search query in mysql in php problem
my search query wont work, i know, that my codes are correct.please help

Code: [Select]&l

php redirecting
i wont open a new thread but i have a question about redirecting....
i wonder why my code doesnt

PHP error. Need help urgently
Hi,

I am programming a php site and have a problem that i just cant find out how to fix. When

Slow data retrieval which requires improvement..please help
I am working on a Help Desk Ticketing system and have a page called MY TICKETS which shows all ticke

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi