From: Noah Silverman
Date: March 20 1999 1:17am
Subject: SELECT distinct date from log
List-Archive: http://lists.mysql.com/mysql/667
Message-Id: <v04003a08b318a5f5300b@[129.37.96.89]>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

Help,

I am trying to get a short list of unique dates from a log file.  There are
numerous records from the same date, but I  only want to see each date once.

I tried:

SELECT distinct date from log

log is the name of the table.
date is the name of a field with timestamp(8).

I get a list of every record in table.  Am I doing something wrong??


-Noah