Hi Duncs, Here are the outputs of each query respectively: SELECT UNIX_TIMESTAMP(status_update_time) FROM nagios_programstatus; +------------------------------------+ | UNIX_TIMESTAMP(status_update_time) | +------------------------------------+ | 1245106276 | | 1245706326 | +------------------------------------+ 2 rows in set (0.00 sec)
SELECT UNIX_TIMESTAMP(NOW()) FROM DUAL; +-----------------------+ | UNIX_TIMESTAMP(NOW()) | +-----------------------+ | 1245681146 | +-----------------------+ 1 row in set (0.00 sec) Let me know if this clarifies anything, Thank you,
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/listinfo/opsview-users
