select extract( day from diff ) days,
extract( hour from diff ) hours,
extract( minute from diff ) minutes,
extract( second from diff ) seconds
from (select TO_TIMESTAMP('06-APR-2015 11.56.11.000000 AM','DD.MM.YYYY HH.MI.SS.FF AM') - TO_TIMESTAMP('06-APR-2014 11.56.11.000000 AM', 'DD.MM.YYYY HH.MI.SS.FF AM') diff
from dual)
var t = $('#red , #blue, #black');
$.each(t, function(number,item){
$(item).addClass("st"+number);
});
p.st1{color:red;font-size:40px;};
p.st2{color:blue};
p.st3{color:black};
<p id='red'>aAAAAAa</p>
<span>1111111111</span>
<p id='blue'>aAAAAAa</p>
<b>22222222222222222</b>
<p id='black'>aAAAAAa</p>
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)\?*$ index.php/$1 [L,QSA]
urlManager'=>array(
'urlFormat'=>'path',
'showScriptName'=>false
...
SELECT *
FROM service
JOIN shopping_service
ON service.serviceid = shopping_service.serviceid
JOIN provided_service
ON provided_service.shoppingserviceid = shopping_service.shoppingserviceid
JOIN provide_service_detail
ON provide_service_detail.providedserviceid = provided_service.providedserviceid