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

How to refresh a parent page from a modal popup
Hi,I have a modal popup in which I need to upload a file and store in the database should give a mes

MS are the best!!!
Visit http://www.microsoft.com/australia/windows/default.aspx?h=watch-a-demo and click the massive '

what business processes?
Hi,

A general question. What business processes (like OTC - Order to Cach, P2P, R2R etc)

Change snippet to use CURDATE
I am using time() in the snippet below, I would like to use CURDATE() and have the database setup fo

Namespace Problem
I'm having problem with a section of code with a variable namespace.

This code works fine:

question about header() security
is is safe to just use the header() function to redirect someone if they are, say, not logged in? or

php unable to sent email
Hi, guys, I try to send a email through php but unfortunately the mail unable to sent. Here is my co

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

passing an array of objects after submit
How do I do this? This is what I have tried and it is not working.

<form method="

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

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