Friday, January 28, 2011

to get duration between time in MySQL- query

SELECT DATE(creation_date) `dt`, creation_date, last_modified, SEC_TO_TIME( UNIX_TIMESTAMP(last_modified) - UNIX_TIMESTAMP(creation_date) ) `duration`, `action`
FROM sms_out_message_analyze
GROUP BY `dt`, `duration`
HAVING `dt` = '2011-01-12'
LIMIT 1500;

Monday, January 24, 2011

How to determine your apache current configuration

/usr/sbin/httpd -l --> List compiled in modules 
/usr/sbin/httpd -V --> Shows the compile settings