.....................
TDateTimePicker *From;
TDateTimePicker *To;
TComboBox *FromHour;
TComboBox *FromMinute;
TComboBox *ToHour;
TComboBox *ToMinute;
......................
Query1->SQL->Text = "SELECT * FROM log.DB L WHERE L.LogDate >='"
+DateToStr(From->Date)+"' AND "+
"L.LogDate <= '"+DateToStr(To->Date)+"' AND "+
"L.LogTime >= '"+StrToTime(FromHour->Text+":"+FromMinute->Text)+"' AND
"+
"L.LogTime <= '"+StrToTime(ToHour->Text+":"+ToMinute->Text)+
"order by L.TerminalNo";
when I run it in sql explorer as
select * from log.DB L where L.LogDate >= '06.06.2006' and L.LogDate <=
'27.06.2018' and L.LogTime >= '00:00:00' and L.LogTime <= '00:00:00'
order by L.TerminalNo
it works
thanks...