Autor | Zpráva | ||
---|---|---|---|
willi Profil |
#1 · Zasláno: 8. 1. 2011, 13:15:03
Toto funguje:
SELECT * FROM mytable WHERE cas BETWEEN '2010-9-1' AND '2010-9-10' AND TIME(cas) BETWEEN '09:00:00' AND '10:00:00' Ale ako pridam naprilad este cas od 15:00:00 do 16:00:00 Niesom odbornik na mysql, dik. |
||
xmark Profil |
#2 · Zasláno: 8. 1. 2011, 13:24:08
SELECT * FROM mytable WHERE cas BETWEEN '2010-9-1' AND '2010-9-10' AND (TIME(cas) BETWEEN '09:00:00' AND '10:00:00' OR TIME(cas) BETWEEN '15:00:00' AND '16:00:00' ) |
||
willi Profil |
#3 · Zasláno: 8. 1. 2011, 13:32:55
super, dik xmark
|
||
Časová prodleva: 13 let
|
0