PheliX Posted August 17, 2005 Report Share Posted August 17, 2005 a kam jaanotiek? parasts select... indexu tik uz taimstampa ieteicams :) Cik saprotu taa paarveidoshana notiek vienreiz un tiek saliidzinaati visi taimstampi ar izreekjinaato. Aa un > vietaa vispaar vajag >= lai sekunde nepazuud :) Link to comment Share on other sites More sharing options...
ffgghh Posted August 19, 2005 Author Report Share Posted August 19, 2005 Izraadaas ka smuki darbojas: WHERE DAYOFYEAR(FROM_UNIXTIME(laiks)) = DAYOFYEAR(CURDATE()) Link to comment Share on other sites More sharing options...
bubu Posted August 19, 2005 Report Share Posted August 19, 2005 haha, un tue neesi iedomājies, ka DAYOFYEAR() arī pagāšgada 19. augustam, ir tāda pati kā šīgada 19.augustam? Link to comment Share on other sites More sharing options...
Kavacky Posted August 19, 2005 Report Share Posted August 19, 2005 haha, un tue neesi iedomājies, ka DAYOFYEAR() arī pagāšgada 19. augustam, ir tāda pati kā šīgada 19.augustam?Ja vien negadās īsais/garais gads. A tad tur galā vēl piemest, vai Y == Y, ne? Link to comment Share on other sites More sharing options...
Analgiins Posted August 19, 2005 Report Share Posted August 19, 2005 nu gan jau aiziet perversijas Link to comment Share on other sites More sharing options...
bubu Posted August 19, 2005 Report Share Posted August 19, 2005 Ja vien negadās īsais/garais gads. Viņam vajag tikai šodienas ierakstus, nevis šīs dienas jebkura gada ierakstsus! Link to comment Share on other sites More sharing options...
Kavacky Posted August 21, 2005 Report Share Posted August 21, 2005 Viņam vajag tikai šodienas ierakstus, nevis šīs dienas jebkura gada ierakstsus!Zinu, tikai nebija īsti precīzi, ja vien vajadzīgā diena nav no 01.01. līdz 28.02. Link to comment Share on other sites More sharing options...
Recommended Posts