Jim, I use Perl. But I was looking for an SQL function/query for doing that. If there isn't any, I welcome any suggestions though.
Thanks On 23 Mar 2002, Jim Philips wrote: > Are you really looking for SQL to do this? Or do you need PHP functions > that will help you to achieve the same result? > > > On Sat, 2002-03-23 at 12:27, Sherzod B. Ruzmetov wrote: > > > > Is there a function or a way to find out how many days/hours/mins/secs > > have elapsed since date n? > > > > For example, i need to be able to get the answer like: "2 days and 3 > > hours have passed since date [some_date]" > > > > Thanks > > > > > > sherzodR > > > > > > -- > > sql, query > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php