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

Opening Multiple Files/Links in Order.
I want to open links in order/one-by-one and check each for a specific string.

Example:
I

cURL proxy
Okay here is the thing... i know how to add proxys

Code: curl_setopt($ch, CURLOPT_PROXYTYPE,

help, header() is not working!
Hello, I have this code:


<?php

/**
* @author samoi
* @copyright 200

remove trailing slash from array
I have the following array which contains trailing slashes I need to remove. What is the best way to

email CODING Problem
Email coding problem.

I need to send a section of the info to $tf and the same as a Cc to $em

php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu

MVC - Code review
I'm in the process of trying to wrap my head around MVC, and as part of that, I'm attempting to impl

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying

Legal Issues for SAP ERP o ERP in general
Hi experts,

Can someone please help me finding some documentation about legal issues tha