unique?

[lukeurtnowski]

I'm running a query which currently outputs all the dates in a field, how do I display non-myltiple dates, that is is a date is output, no dupliccate of it woldbe produced?
Here's how I think...
SELECT UNIQUE date from activity;

right?
Thanks..

[Drakla]

SELECT DISTINCT date from activity;

[lukeurtnowski]

thanks