|
Posted by meltedown on 08/23/05 03:36
Tim Van Wassenhove wrote:
> On 2005-08-22, meltedown <groups2@reenie.org> wrote:
>
>>
>>This represents 2 fields in a mysql database
>>[login] => 2005-08-22 18:04:41
>>[logout] => 2005-08-22 18:05:08
>>
>>I want to find out the difference between these 2 times.
>>I don't have access to mysql's DATEDIFF function.
>
>
> You could calculate the difference yourself:
>
> SELECT UNIX_TIMESTAMP(logout) - UNIX_TIMESTAMP(login) AS secondsdif
>
>
Thanks, that works.
Navigation:
[Reply to this message]
|