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

On page view, minus credit
Hello all, please, I need a little help with this script. I am charging one credit (credits can be p

How do I get the row number from from an sql table query
Hi all

I have a table that I query and it returns a number of rows.
mysql_num_rows($query)

Quick fix: Conditional statement with an array
Hi, I'm getting the temperature value off of the Environment Canada website along with the icon file

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

How to concatenate (add) both of them $str

Regular expression tips or resources
Hello! I'm having some issues implementing the appropriate regex patter to eliminate unwanted charac

turning an array into a string then poping it into a db
Hi im just wondering how you get a requested array into a single string then pop it into the db so f

can i optmize image to 50% quality before uploading 2 server
Hi there

i have jus written a php program to upload and display images but when i try to uplo

Dealing with code in db query
I am dealing with C code and I need to make sure it is encoded some how to ensure its integrity and

extract content from a website
i have written a code that will grab the content from the index page..
i would like to know how c

Session
I am having a little trouble with a session. Not sure if it is my browser or what. I know I do not