i am using MySQL database. i have one field PurchaseDate. i want following result
e.g. : PurchaseDate between May-2010 and Aug-2011
pls help me to solve this problem. its urgent. thanks in advance....
mitmehta22 0 Newbie Poster
wen_cai -3 Junior Poster in Training
Have you consider using the between keyword?
SELECT columns
FROM tables
WHERE column1 between value1 and value2;
mitmehta22 0 Newbie Poster
yes i have tried between keyword but its not working because i want to filter only month & year. if full date is given then no problem but when i give only month and year, it is retieving records but they are not in range. i have also tried month(), year() and date_format() functions.
my sql is like follow:
select date_format(purchasedate,'%d-%M-%Y') from purchase
where date_format(purchasedate,'%m-%y') between "05-2010" and "08-2011"
mitmehta22 0 Newbie Poster
i have solved my problem. in sql i have added one month.
for ex. i need record between May,2010 and Apr-2012 so the sql is like follow:
Select DATE_FORMAT(PurchaseDate,'%d-%M-%Y') as PurchaseDate
from Purchase
where PurchaseDate >= '2010-5-1' AND PurchaseDate < '2012-5-1'
azareth 5 Posting Whiz in Training
this should be marked as solved
mitmehta22 0 Newbie Poster
how can i mark it as solved?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.