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

Using CSS to format MySQL query
Hi,

If i want to have a news page on my site, which displays all records of a table in descen

Display a default image
I am trying to display generic image for items that don't have one, but I can't get it to display.

small inaccuracies
I have this code to convert fractional base 10 into base 2:

while($num > 0)

Concatenate two strings ???
I have string one $string1 and another $string2.

How to concatenate (add) both of them $str

Windows Authentication
I have a website which is windows authenticated.
now i want something more on this application.<

Best way to cross matching large datasets
Hi,

Im running a script where am I cross matching about 200 000 data sets with each other. Ea

Serial number of exernal hard disk/Thumbdrive
Hi guys, I am new tio java networking concepts.Please tel me how to get Serial number of exernal

mails going in spam??
The mails I sent to folks in my database using mail(function) are going in spam??

Any idea ho

How to submit a form to the same page?
I have a table containing information about books in my library and this table has the following col

Not showing whole name with mail () script
I sent up a simple mail form with the PHP mail() script. One problem is when it sends an email with