Tema: Re: Padekit su mysql SEC_TO_TIME
Autorius: dz
Data: 2010-08-27 07:45:19
<!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.6001.18943">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>tai gal ikarto naudoti funkcij "format" (daro t pat, kaip 
"Text" excel'yje), joje juk nurodomas formatas, kaip bus suformuotas tekstas. 
Tiesa, neaiku, koks DBVS. A toki f-j Access'e naudojau. Gal kitur nra 
tokios.</FONT></DIV>
<BLOCKQUOTE 
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px" 
dir=ltr>
  <DIV>"zigmas" &lt;<A 
  href="mailto:montag26@gmail.com">montag26@gmail.com</A>&gt; wrote in message 
  <A 
  href="news:i55m5e$h3$1@trimpas.omnitel.net">news:i55m5e$h3$1@trimpas.omnitel.net</A>...</DIV>
  <DIV><FONT size=2 face="Microsoft Sans Serif">Sveiki,</FONT></DIV>
  <DIV><FONT size=2 face="Microsoft Sans Serif"></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 face="Microsoft Sans Serif">padekit, problema 
  tokia:</FONT></DIV>
  <DIV><FONT size=2 face="Microsoft Sans Serif"></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 face="Microsoft Sans Serif">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 size=2 face="Microsoft Sans Serif"></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 face="Microsoft Sans Serif"></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 
face="Microsoft Sans Serif">Dekui</FONT></DIV></BLOCKQUOTE></BODY></HTML>