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
|