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

Escape Latin Characters
I need to escape latin characters in an xml doc. Example: "é" is escaped to "é". I thoug

PHP & Java
Hello,

can PHP code be used inside java code?

Code: [Select]<SCRIPT LANGUAGE=&q

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Dynamic links in an include file 
I am working on a small piece of code that counts records from a database and displays the result to
Images in email problem 
I found this script for sending emails, it works but if the email has <img src="image.jp
Dynamic Data + Sql Server 2005 Enterprise? 
Hi! I have just started to learn ASP.NET, and it looks like it is quite a lot to learn. Im not reall
MSSQL/PHP 
I am tryint to setup a webapplication developed in PHP, Apache2.0 and SQLServer2000 as backend which
Variables and Include 
Code: [Select]<?php

$header = $_COOKIE['mss']['header'];
$body = $_COOKIE['mss']['b
I need an iframe that calls up a different page according to the date  
hi

I don't know any php (only html) and I urgently need to do the following:
 
I need a
PL/SQL: ORA-00947: not enough values error message 
Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing