select * from table
where extract(time from date) <> '00:00:00'
select uid, lvl, exp, money, gold, name
from users u, matrix m
left join objects o on m.object_id=o.oid
left join cultures c on o.cultures_id = c.cid
left join grounds g on o.ground_id = g.gid
where m.matrix_id=u.user_id
TextView myTextView = (TextView) findViewById(R.id.myTextView);
<script>
var t;
function _w_up() {
var top = Math.max(document.body.scrollTop,document.documentElement.scrollTop);
if(top > 0) {
window.scrollBy(0,-50);
t = setTimeout('_w_up()',2);
} else clearTimeout(t);
return false;
}
</script>
<style type="text/css">
.btnUp {
position: fixed;
right: 40;
bottom: 0;
padding: 10px;
background: 1 solid #000;
background-color: #eeeeee;
color: #000;
min-width: 20px;
}
</style>
<style>
#__goUp {
background-image: url(/scrollUp/action/png/goUp);
background-color:transparent;
width:50px;
height:12px;
}
</style>
<a onclick="_w_up();"><div id="__goUp" class="btnUp" style="visibility:hidden">@@UP@@</div></a>
<script>
window.onscroll = function(){
document.getElementById('__goUp').style.visibility = (window.pageYOffset > 0 ? '' : 'hidden');
}
</script>
SELECT`s1`.`title`,`s1`.`description`,`s1`.`contacts`
FROM `spec` AS `s1`
LEFT JOIN (
SELECT concat(`contacts`,'.', 'title') as contacttitle, COUNT(`contacts`) AS `count`
FROM `spec`
GROUP BY 1) AS `s2` USING (`contacts`)
WHERE STATUS='' ORDER BY id DESC;
SimpleDateFormat frm= new SimpleDateFormat("dd.mm.yyyy");
String tst = "17.05.2014";
try {
Date date = frm.parse(tst);
System.out.println(date);
System.out.println(frm.format(date));
} catch (ParseException e) {
e.printStackTrace();
}
SELECT EXTRACT(YEAR FROM DATE expDate) FROM Table1
where EXTRACT(MONTH FROM DATE expDate) = 2
function getXMLHttp()
{
var xmlHttp
try
{
//Firefox, Opera 8.0+, Safari
xmlHttp = new XMLHttpRequest();
}catch(e){
//Internet Explorer
try{
xmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
}catch(e){
try{
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}catch(e){
alert("Your browser does not support AJAX!")
return false;
}
}
}
return xmlHttp;
}
function MakeRequest(action, id)
{
lastAction = action;//alert(action + ' ' + id);
state = '';
divMakeReq = document.getElementById('makereq');
divMakeReq.innerHTML = 'Action:' + action +'; id:' + id;
divError = document.getElementById('err');
divError.innerHTML = '';
var xmlHttp = getXMLHttp();
xmlHttp.onreadystatechange = function()
{
if(xmlHttp.readyState == 4)
{
if (xmlHttp.responseXML != null)
HandleResponse(action, id, xmlHttp.responseXML);
}
}
xmlHttp.open("GET", aLink+ "/action/"+action+"/"+id, true);
xmlHttp.send(null);
}