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

need help in update query
hi
i have a dynamic form. i need help in how can i use update query when values from dynamic for

send message to the java application
Oracle 10g with Windows platform.

I have a java application that periodically pings the d

Required to login help
I'm trying to set up my site so users have to be logged into the forum to access the site.I've been

PHP5 - Verifying a secure mail is secure
I need to send an e-mail from a form to a external department and because it contains personal custo

Blocking video streaming
Hello everyone,

I post a message here because i didn't find any solution yet.
I just finis

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

Move array index to end
Hey guys,
Quick question:

I have an array that looks like this:
Code: [Select]$var =

Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Ora

First root of a number
Hi,

I can't find any function in php to give me the first root of a number.
Is there any

frames get header location..
i have two frames, one top, one bottom. how do i do a form on the bottom frame that gives me the ur

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