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

Drawing Images in classes
I'm quite new to Object Oriented PHP. What I'm trying to do is draw some images but also have other

Bandwidth monitoring?
Hi guys,

I need a little information I have written a php app and I occurred to that I need

Query failed issue with php script but works fine in mssql manager!
hi i have the script below which copies data from one table to another but will only insert new data

Form Help
Here is the form:

Line number On/Off | Expand/Contract<? include("../include/sess

Displaying values from a SQL count...
Hi,
Easy enough question i just forget the exact method ..
I have ...

Code: //count win

How to generate a random array of integers subject to a certain constraint
I am writing a program that asks the user to enter an integer N and then generates a random array of

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

Sum of Values in an Array
This is probably really simple... but it's been years since I've written anything, so bare with me!<

Getting a variable to work in function params
I have this fuction which is inside a class:

Code: public static function generateEmbedCode($

Problem with a select distinct
I have a problema with a select distinct, I have the next sql:

select distinct a,b,c,d fr