> hey hey... relax Martijn,
> i don't want another fighting over time issue.. ;)
>
> Hi dude,
> TIMESTAMP is a time-detailed calendar data format.
> Can you represent difference of two calendartimes as in calender
> format?
> No, of course.
>
> But you can display it in human readable format:
>
> (checkout-checkin)/84000 gives you the number of days delta.
>
> cast('00:00' + ((checkout-checkin)-(days*84000)) as time)
>
> gives you remainder time value in time display format.
>
> As you see, there is two result and usage of them is up to u.
>
> Regards.
> Ali

I like it... you could also go to weeks like this but months are out of the
question
:-(
Alan