MySQL Forums
Forum List  »  Newbie

Can datediff be used?
Posted by: Karen Smith
Date: December 08, 2006 03:18PM

I have a table that has 3 columns an id, date, and a userid. I want to find the holes in the date column so that I can assign a user to those unused dates. I have been trying to figure out how to use datediff to do it but haven't succeeded yet. Is it possible? I only need to find the first hole or the end of the list.

The data might look something like this
ID date UserID
1234 12-22-2006 3456
2312 12-24-2006 9860
4352 12-25-2006 3482
3987 12-27-2006 6843

Options: ReplyQuote

Written By
Can datediff be used?
December 08, 2006 03:18PM
December 08, 2006 03:24PM
December 09, 2006 06:42AM
December 11, 2006 11:53AM
December 11, 2006 01:16PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.