Rich,
You can try TO_DAYS() first before finding the diff. of the two dates. Perhaps this
would give you a better solution.
Hasan
----- Original Message -----
From: "Rich Duzenbury" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2001 5:22 AM
Subject: Elapsed time
> Ver 8.0, Distrib 3.22.32.
>
> I have two fields in a table that are TIMESTAMP fields. I'd like to show
> the amount of elapsed time between the two timestamps in a human readable
> format. For example, I'd like to print 'Elapsed time: 1 year 4 months 27
> days 9 hours 13 minutes 42 seconds. ' Or perhaps 1-4-27 9:13:42.
>
> I've tried
> SELECT SEC_TO_TIME(date2 - date1) from myfile
> Differences of more than 24 hours appear to accumulate in the hours field -
> it show things like 225:18:07.
>
> I've also tried
> select FORMAT_DATE((date2 - date1), '%Y-%c-%e %T') from myfile.
> most records return NULL..
>
> Can an SQL query calculate and display the elapsed time? If so, could you
> provide a simple example? If this isn't feasible, I can certainly
> calculate the difference in the code if need be.
>
> Thank you.
>
> Regards,
> Rich
>
>
> ---------------------------------------------------------------------
> 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