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

reorder sql query
ok so i have this very simple code:
Code: $query = "SELECT search_keywords, COUNT(search_key

How would I protect......
I have a from, actually, a good amount of forms. How can I make it so you can't type the characters:

Mysql error message
help me find out what this error message means:

"Duplicate entry '0' for key 'PRIMARY'&q

Adding meta tags under Zend FW
Hello there, recently has come to my hands the FTP of a website which is running under Zend, I would

Need Reporting Advice
My SQL server doesn't support MS SQL reporting services that comes with SQL Enterprise or Express. T

single page with referrer to show correct page
I have a simple website with a couple of different pages. I would like to be able to in a div tag w

HTML form problem
Ive made a form to that i want to send to my email via PHP. but when it send only the name's etc sen

Displaying an image using echo command
I had done a query on my database, one of the fields being an image reference to a directory where a

Need help in log in and log out?
hi there all of u. i have recently created a site for someone. i have placed log in and log out and

Calling strings from other php class
I have test1.php{
$string1;
$string2;
....
... //10 strings in this class <