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

Option box to change variable
Hello, i need help by making a script!

I need to write a file with option box, so a dropdown

Batch update record with Pagination
Hoping someone can help me with this issue I'm having, im trying to batch update records from a resu

Libraries in C++
Hi all,

I have two libraries. one is based targeted on linux platform and uses another li

Filtering Tables
Hello Thanks for any help any one can give Im very new to PHP..

I need to pull data for clien

retrieving policy name inside the function called by this particular policy
Hi there,

I've playing around with dbms_rls package, trying to set up some security repo

Google voice
I currently have a form in html, but I want it in php so the information is not in the source code.<

How to implement HTTP connection timeout
Hi All,I would like to implement an HTTP connection timeout.

I am working on a application wh

Syntax error
hi im having a little trobble with this script
-------------------------------------------------

output printing as hexadecmal... XD
Everything works except the calcem call for the totusold and totuprice. The out put shows up as hex.

breaking a text file into paragraphs based on strings
I have a text file of email addresses that is all squished together. It looks like this:

abc