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.

Did you know?Explore Trending and Topic pages for more stories like this.
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

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

Creating a custom API
I'm creating a site, and I need to create a basic API. Unfortunately I have no idea where to start.

Display data returned from Ajaxservices!!
I have a question about displaying results using ajax. I have part of the code below.
$.ajax({

Database connection failure
Hello All,

I am trying to create new connection to Oracle DB 10.1,
I could not see a

Upload file and add HTML
Hey everyone,

I have a client has meeting agendas and minutes that should be posted online. I

Need help in Generating Combinations
Need help generating all possible combination of names in an array

Lets say i have the follow

Parse Error with doctype
I'm getting a parse error with this simple code. I don't get it. It worked one time then when I relo

Help with writing "$" with fopen
I just can't get my syntax correct. Could someone help me please? I am trying to write a connect fil

upload image name with extension using php
hi frds..

<input id="file1" type="file" name="file[]" &a

Help With editting and deleting form
Hallo !!

So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.pn

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