SELECT distinct date from log

[Noah Silverman]

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