get date between defined hours

[purs]

hello ,
i need to select some date values that are between 9:30 and 18:30 everyday.How can i do this in mysql?

[amitpatel66]

Hi,

Welcome to TSDN.

Your requirement is not clear. Please provide more details on your requirement so that our experts would help you.

[ronverdonk]

Do you mean something like

select myDate from table_name where myTime between '09:30:00' and '18:30:00';

Ronald

[purs]

Do you mean something like

select myDate from table_name where myTime between '09:30:00' and '18:30:00';

Ronald

yes,but i have date in DATETIME format not in TIME...
can i do something like:

select myDate from table_name where TIME(myDate)>='09:30:00' and TIME(myDate)<='18:30:00'; 

[ronverdonk]

Please enclose your posted code in [code] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.

Please use [code] tags in future.


Yes, but use the BETWEEN, is a lot easier, like

select myDate from table_name where TIME(myDate) between '09:30:00' and '18:30:00'; 

Ronald

[purs]

thank you :) It works

[ronverdonk]

Of course it does! See you around.

Ronald