Tema: Padekit su mysql SEC_TO_TIME
Autorius: zigmas
Data: 2010-08-26 15:19:58
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1257">
<META content="MSHTML 6.00.2900.6003" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face="Microsoft Sans Serif" size=2>Sveiki,</FONT></DIV>
<DIV><FONT face="Microsoft Sans Serif" size=2></FONT>&nbsp;</DIV>
<DIV><FONT face="Microsoft Sans Serif" size=2>padekit, problema 
tokia:</FONT></DIV>
<DIV><FONT face="Microsoft Sans Serif" size=2></FONT>&nbsp;</DIV>
<DIV><FONT face="Microsoft Sans Serif" size=2>vien zodziu issitraukiu is 
duombazes kiek sekundziu darbuotojas per menesi pradirbo, paverciu sekundes i 
normalu laika formatu SEC_TO_TIME(darbo_valandos) rezultatas tarkim 150:48:45, 
dabar man reikia sql uzklausoje(kad nekurti papildomu lenteli visokiu paversti 
TIME format i CHAR, kap slq uzklausoje tai padaryti blyn.</FONT></DIV>
<DIV><FONT face="Microsoft Sans Serif" size=2></FONT>&nbsp;</DIV>
<DIV><FONT face="Microsoft Sans Serif" size=2></FONT>&nbsp;</DIV>
<DIV><FONT face="Microsoft Sans Serif" size=2>Dekui</FONT></DIV></BODY></HTML>