>>>>> "K" == KevinWaterson <kevin@stripped> writes:
K> of months between two dates.
K> I have a date format like 2000-02-20 06:55:06 and 2000-02-20 08:27:31
K> How do I best find how many seconds have elaped here?
You convert the dates to number of seconds since a pre-determined
time, then subtract.
This is just a matter of converting your given value into the units of
interest.
| Thread |
|---|
| • mysql_value(res,i,j) wanted :-) | (Alexander Barkov) | 28 Jan |
| • Re: mysql_value(res,i,j) wanted :-) | sinisa | 28 Jan |
| • ANSWER: mysql_value(res,i,j) wanted :-) | Michael Widenius | 29 Jan |
| • Re: ANSWER: mysql_value(res,i,j) wanted :-) | Benjamin Pflugmann | 30 Jan |
| • Re: ANSWER: mysql_value(res,i,j) wanted :-) | Michael Widenius | 30 Jan |
| • Re: ANSWER: mysql_value(res,i,j) wanted :-) | Benjamin Pflugmann | 30 Jan |
| • Re: ANSWER: mysql_value(res,i,j) wanted :-) | Michael Widenius | 5 Feb |
| • dump error | kevin | 7 Feb |
| • Re: dump error | sinisa | 7 Feb |
| • DATE arithmatic | KevinWaterson | 21 Feb |
| • Re: DATE arithmatic | sinisa | 21 Feb |
| • Re: DATE arithmatic | Vivek Khera | 21 Feb |
| • triggers ? | KevinWaterson | 12 Mar |
| • Re: triggers ? | Jonathan Stimmel | 12 Mar |
