3 Mar
2010
3 Mar
'10
10:57 p.m.
On Wed, Mar 3, 2010 at 6:43 PM, Peter Karunyu <pkarunyu@gmail.com> wrote:
Good evening skunks, I am retrieving the data below from a MySQL table, I want to display it on a page as follows: for any given day, I want to show the earliest time and the latest time, (for example, 2010-02-02 09:53:00 and 2010-02-02 10:50:00) on one row.
try this : select min(aDate), max(aDate) from tblDate group by date(aDate)