Page 1 of 1

select between date and time mysql

Posted: Sun Mar 01, 2009 7:55 pm
by junjustkim
hi to all

I have field date and time respectively. I want to select date between (date1 and time1 > 17) and (date2 < 17)

I tried in two ways but it doesn't work, please see code below.

any suggestions would greatly appreciated

tnx

tirso

Code: Select all

 
SELECT * from purchases_suppliers WHERE (date_invoice >= '2009/02/25' and time_invoice > 17) AND (date_invoice <= '2009/02/27' AND time_invoice < 17)

Code: Select all

SELECT * from purchases_suppliers WHERE date_invoice between ('2009/02/25' ANd time_invoice > 17) AND ('2009/02/27' AND time_invoice < 17 )

Re: select between date and time mysql

Posted: Tue Mar 03, 2009 12:20 am
by Dinosoles
Hi,

It does depend on the type of fields, if the date_invoice was stored as datetime then this would workfine...

Code: Select all

SELECT * from purchases_suppliers WHERE date_invoice BETWEEN '2009/02/25 17:00:00' AND '2009/02/27 16:59:59'
If not then try the MySql DATE_FORMAT function.

Hope this helps.