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

webpage with (simple) login & mysql-db
Hi all,

What I was looking for before was a multi-user password manager, web-based! The offer

Please help with code for SMTP authenticated PHP email form
Hello, I'm creating a PHP email form, and for this particular server, I have to use SMTP Authenticat

Calling a Procedure with IN & OUT Parameters
Hello,

I usually call my procedures using the following way

declare variable e

Calander layout
Hi i know this sounds like a simple question but i cant find the answer to it anywhere i have added

php title problem
Hi,

I am having a problem managing my page title with PHP.

Currently I have my <

php slowing my site?
Hi all,

I think that one of the reasons that my site doesn't work fast is that the code is ve

php multiple action on submit
I have a form which says:

<form enctype='multipart/form-data' method='post' action='pr

SQL query not working well
Hi,
I made a small table with 5 rows and want to make them an sql consult using rownum

Preloading images
Posting this question here because I am not sure where this should belong.I am building an asp.net a

LIMIT $start, 10... how to pass last value queried into next page with GET??
Ok I know how to display the first or last 10 results of a query...

$result = mysql_query(&q

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