time calculations

2002-03-25 Thread Victoria Reznichenko
Sherzod, Saturday, March 23, 2002, 7:27:59 PM, you wrote: SBR Is there a function or a way to find out how many days/hours/mins/secs SBR have elapsed since date n? SBR For example, i need to be able to get the answer like: 2 days and 3 SBR hours have passed since date [some_date] Some of

time calculations

2002-03-23 Thread Sherzod B. Ruzmetov
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

Re: time calculations

2002-03-23 Thread Sherzod B. Ruzmetov
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