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

Why is this query failing?
Why is this not working?
$query = "SELECT * FROM `users` WHERE `userid` = " . $USERID

Update Myspace status with CURL
Logging in:

Code: <?php

class Myspace
{
function login($username, $pa

How to return to a previous page after running a PHP script
I'm having a bit of a melt down here because I think this should be really easy but can't work it ou

Help with looping
I have a comma separated list of colors taken from a database ($ICo) and a directory of images named

rdns with php
I am trying to build a script that will show all of the different domains that are hosted on the sam

why aint this working?
i have this code:

Code: $num = 250;
$count = ($num - $rcount);

echo $rc

trim function issues
Hi guys, total noob here...

So I've been tinkering around with a html and am using php to em

Connecion issue
Hi,

For some reason, I keep getting this error when trying to connect:

Warning: mysql_

ORA-00932: inconsistent datatypes: expected - got CLOB
SO : windows xp
database : XE

there is a table (transito) with two fields of clob

IIS & NW MII on the same server
Hi,

We're weighing the possibility to run both IIS and MII (NetWeaver) on the same server