MySQL Forums
Forum List  »  Newbie

Re: Calculating TIME ELAPSED SINCE in days OR hours OR minutes
Posted by: Jay Alverson
Date: February 27, 2009 08:48PM

Actually I think it's

< 60

> 59

< 1440

> 1439

since those are technically the cutoffs from one group of measurement to the others...my example was just the quickie way.

I think you can also use BETWEEN to eliminate the < > stuff. It's inclusive as well.

>

Thanks, Jay



Edited 1 time(s). Last edit at 02/27/2009 08:48PM by Jay Alverson.

Options: ReplyQuote




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.