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

asking for direction
I have 2 tables in my data, which are "post" and "event"
I won't make a summa

Check Digits and extracting digits
I think I can figure out the code for this but I am having a very hard time getting past the first s

extract content from a website
i have written a code that will grab the content from the index page..
i would like to know how c

how to timeout $doc = new DOMDocument()->load($url)
I am currently using this $doc->load($url) to fetch an rss feed.
If a feed takes long than

Need help with a mail notify function
I was tasked with setting up a site that's been prewritten. The site is basically a form that captur

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see

Run function every 5 mins ??
I have a function PostMessage()

How can I run it every 5 mins ??

Greek characters in php
Hi,

I'm making a script and I m using for first time greek characters.
I started to write

Change snippet to use CURDATE
I am using time() in the snippet below, I would like to use CURDATE() and have the database setup fo

.htpasswd Registration Form
Hi,
I wanted to make an htpasswd registration form.
I found this code on the internet but have