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

No comments posted yet

Your Answer:

Login to answer
243 Like 17 Dislike
Previous forums Next forums
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

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash