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

No comments posted yet

Your Answer:

Login to answer
243 Like 17 Dislike
Previous forums Next forums
Other forums

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

What makes a script your own?
If someone finds a login script online, and changes some variable names around and some other minor

Help with Hyperlink
Hi,

What I am trying to do may be simple, I just can't get it to work. Ok...

I am usin

Displaying an image using echo command
I had done a query on my database, one of the fields being an image reference to a directory where a

Thread in PHP
Thread in PHP
Some basic use and basic code for thread in php
This is my question?

rand() function
just a general question guys a girls, is the rand() function 100% random or is it based on time?

SQL Injection
In my attempts to protect my database from mySQL injection I have created another problem for myself

RSS feed - FeedList for WordPress
Hi,

I'm trying to alter the FeedList plugin for WordPress so that I can click on the title of

Different actions for different parts of a string
<?php
function dosomething($string, $else = '') {
if (empty($else))
$string

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

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash