MySQL Forums
Forum List  »  Newbie

Distinct(date_format())
Posted by: Rambabu k
Date: July 01, 2005 12:31AM

Iam writing a Query to Select a Distinct Date depending on the format.

When the Following Query is Run in MySQL 4.0 It is working fine and displaying
distinct dates.
When the same query is executed in MySQL 3.23.49. It is not fetching the
distinct dates it is displaying duplicates date. What is the Problem . Is it the
problem with version of MySQL? If so from which version it will be supported.

The Query I executed is:

SELECT DISTINCT DATE_FORMAT(A.RECORDEDDATE,'%Y-%m-%d') AS RECORDEDDATE FROM
table1 AS A, table2 AS AK WHERE AK.KEYID = 24 AND A.ARTICLEID = AK.ARTICLEID
ORDER BY A.RECORDEDDATE DESC



I think the problem is with MySQL Versions only. Is it So?

Please suggest me the solution AS soon as possible

Options: ReplyQuote


Subject
Written By
Posted
Distinct(date_format())
July 01, 2005 12:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.