[SOLVED] SQL - cast datetime to date.

[peterjc]

at database, there is a field call time to store this value: 2008-7-30 13:16:10

 

So, at the sql statement, i use:  SELECT id FROM tablename where time='$today';

 

The $today is like 2008-7-30 13 (without the second)

 

but because the time stored contain second(2008-7-30 13:16:10),

 

so how to use mysql to cast the time from 2008-7-30 13:16:10 to 2008-7-30.  become without second?

 

Thank.

[Barand]

DATE(datetimecol)