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

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

problem with php mysql query
Hi guy's...

I'm totally lost here..because don't have any idea how to make a query for grab r

How can I Compare two xml documents?
Hi all,

I am doing a POC for my project and I am using XE database 10g version.

Track downloads' status
Hello,

I need to make somehow, some system, to track whether downloads are completed or faile

Quick Syntax Question
Hi folks,

I'm getting the following error: "unexpected T_LNUMBER". I'm trying to b

Select question
Hi,

First I would like to say that php is pretty new for me..
so please don't shoot me if

pagination numbering pattern
Hello,

I have following code which works great for pagination. but i have small issue now.

include function being weird?
I have a very simple system to grab an IP outputted by a PHP file.. (for a project I have) but it ou

Stopping page post back
I have few literal contriols in my page and a repeater too. But inspite of using update panel, postb

error help - Dynamic Image
I've been working on making my site less cluttered in the directories and more secure lately. In an