I need to fetch records between defined date ranges i.e Date from 01/08/2006 to 15/08/2006.
I am using following command to do above task but its not bringing accurate data.
SELECT * FROM ABC WHERE date BETWEEN '01/08/2006' AND '15/08/2006'
Can anyone help??
MYSQL - Date match
1 reply to this topic
Posted 24 August 2006 - 02:53 PM
would the date format not be YYYY-MM-DD and not DD-MM-YYYY therefore as far as i know "SELECT * FROM ABC WHERE date BETWEEN '2006-08-01' AND '2006-08-15'" should work
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users