MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Noah Silverman Date:March 20 1999 1:17am
Subject:SELECT distinct date from log
View as plain text  

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??


SELECT distinct date from logNoah Silverman20 Mar
  • Re: SELECT distinct date from logThimble Smith20 Mar