Hi Guys,

Ive got a DB with 10000's of rows, Each has a datetime stamp in the following format:
2010-07-07 12:20:36
2010-07-07 12:30:36
2010-07-07 12:40:36

How can i select just ONE row from each day?
( It doesnt matter what row, As long as its from that day.. )

Ie:
2010-07-07 12:20:36
2010-07-08 12:30:36
2010-07-09 12:40:36

Any thoughts?
Google isnt helping me at the moment

Thanks
G

... GROUP BY date(column) ... ;

Ahha,
Sweet, Thanks again mate.

So simple but i evidently didnt ask google hard enough

Thanks again.

-G