baber_abbasi Posted August 24, 2006 Share Posted August 24, 2006 Hi,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?? Quote Link to comment Share on other sites More sharing options...
shocker-z Posted August 24, 2006 Share Posted August 24, 2006 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 workRegardsLiam Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.