elapsed time

I am probably postin to the wrong list but....

I am having timestamp problems...

if mc_last_change is a timestamp,

select minute(CURRENT_TIMESTAMP()-mc_last_change) as
elapsed_time from machines

frequently returns NULL even though the mc_last_change holds
a valid timestamp.

At the same time CURRENT_TIMESTAMP()-mc_last_change
returns a valid number.

Any idea why?

Cheers,
Dave.



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org