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

help countdown timers
hello every one,

I'd like to know how to insert many countdowns in the same page.
The dura

php global variable
how can we create global variable so we can use its value in any form.. Please give example to

PHP url branch??
Functionally, using PHP, I'm doing a test of login input submitted by a user via an html form in a f

Parse Error
Hi Guys,

I have a function in my class which returns a string link variable. The problem is i

Need help with basic sql
Hi,

I am using oracle 10g, and having some small doubts related to sql , here goes the si

Target costs on Process orders not calculating
Hi All,

We have released standard costs for all the materials. We have also done Goods r

Need help: how to catch acess of undefined class properties
Hello. I am learning OO with PHP and have hit a problem.
Some code runs as perfectly valid code,

Problem Dereferencing
With these types and tables:

CREATE TYPE MANAGER AS OBJECT (
MGR_ID INTEGER,

Encrypt php code?
Is it possible to encrypt php code in files,
so that it displays a load of unreadable characters

Using system() and bringing back the results
I am aware that you can use system() within PHP to execute system commands, but I was wondering if t