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

Snapshot from video
anyone knw how to make a snapshot maker from avi n mkv format.
for example if i give a direct lin

Install page
How do I make it so when a user submits information on the Install page, it'll right it into the cor

Redirect not working after making a POST/GET
Hi Everyone,

I am a novice in PHP. Here I have 2 pages, one page with a textbox and button an

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t

close site for maintenance
i get a tutorial, saying the following code can put our site offline, and only the developer can vie

Creating a custom API
I'm creating a site, and I need to create a basic API. Unfortunately I have no idea where to start.

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

Struct/union and scope problem!
HI all , I have
Code: in header.h typedef struct Node Link; /* ---------

i have no idea why this isn't working
Code: <?php
session_start();
include("connect.php");

error_reporting(E

All possible combinations of Strings from table in PL/SQL
Hi,

I am trying to figure out how to build a list of all possible string combinations fro