Tema: Re: MYSQL selectai su datom ir laikais
Autorius: Linas Petkeviius
Data: 2010-05-13 10:33:20
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=windows-1257 http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16535">
<STYLE></STYLE>
</HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody leftMargin=0 topMargin=0 bgColor=#ffffff
CanvasTabStop="true" name="Compose message area">
<DIV><A
href="http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff">http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff</A></DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV>"zigmas" <<A
href="mailto:montag26@gmail.com">montag26@gmail.com</A>> wrote in message
<A
href="news:hsg9hs$heb$1@trimpas.omnitel.net">news:hsg9hs$heb$1@trimpas.omnitel.net</A>...</DIV>
<DIV><FONT size=2 face="Microsoft Sans Serif">Reikia atkasti kiek darbuotojas
isdirbo valandu per diena. Tarkim atejo i darba 2010.05.13 08:02 isejo is
darbo 2010.05.13 17:58 isdirbo 09:56 val.</FONT></DIV>
<DIV><FONT size=2 face="Microsoft Sans Serif"></FONT> </DIV>
<DIV><FONT size=2 face="Microsoft Sans Serif">Bandau rasyti uzklausa bet b
gaunasi.</FONT></DIV>
<DIV><FONT size=2 face="Microsoft Sans Serif"></FONT> </DIV>
<DIV><STRONG><FONT color=#000080 face="Microsoft Sans Serif">SELECT
TIME(isejimo is darbo laikas - atvykimo i darba laikas) as kiek FROM
lentele</FONT></STRONG></DIV>
<DIV><STRONG><FONT color=#000080
face="Microsoft Sans Serif"></FONT></STRONG> </DIV>
<DIV><FONT size=2 face="Microsoft Sans Serif">gal patarti galit.</FONT></DIV>
<DIV><FONT size=2 face="Microsoft Sans Serif"></FONT> </DIV>
<DIV><FONT size=2
face="Microsoft Sans Serif">Dekui</FONT></DIV></BLOCKQUOTE></BODY></HTML>