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

storing video files into mysql in php
hi

i have my video files in my folder ,
i have to store the path of the videos into db an

User registration and login
I don't know whether this is the correct forum, if not i apologise but am pretty desperate at the mo

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

Sorting JTable on more than just the values listed in the columns
I have a collection of objects that store (among other things) two integer values. I only want to di

Sessions work for me and not others?
I'm having a bit of bad luck with sessions. In the past they have worked fine for me, but this time

Sending a hyperlink through mail
HI all,
I am sending a mail to outlook mailbox of a user using FM SO_NEW_DOCUMENT_ATT_S

onClick='location.href=index.htm'> not working
Below is my code:

echo "<input type='button' value='redirect' onClick='location.h

Reading waves
Hi,

I am trying to find a way of finding the highs and lows on a graph line, the line points

server trace logs
could any one tell me from where do i get error logs in xMII??I want to check the reason for dtabase

Simple Variable Question
Hi everyone.... again,

I am really getting into php still. Learning more every day. I love it