Re: datetime and date combine

select * from samp_test where dow = weekday(today) andcurrent hour to minute between from_time and to_time On Tue, 24 Nov 1998 jjdai@hotmail.com wrote: > Hi friends , > > I have a question during my developing , > I have two columns in a table , the data type of the first( column A) is DATE > and another ( column B ) is DATETIME HOUR TO MINUTE , > the column A means the date that the data inserted , > the column B means the time that the data inserted , > > now , I want to develop a program that user can entry a start > date(in the form file it is defined as DATE type )and time (it is defined > as DATETIME HOUR TO MINUTE type ) and then entry a finish date and time > ,the program will search out the records inserted between the user defined > duration , > > but when I write the program I can not convert the date and datetime type , > and can not compose the query statement . > > can you give me any advice . > > Thanks in advance > > > JianJun (jjdai@pek-co.cn.dhl.com) > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own >