[RESOLVED] Getting Date From Timestamp?

[Channel5]

Hi,

My 'date' column is a timestamp but I want the WHERE statement to retrieve just the date (Y-m-d), and hack off the time. Totally forgot how to do this.

Can anyone show me the solution?

Thanks!

		$users = mysql_query("SELECT * FROM users
		WHERE DATE_FORMAT(date, '%Y-%m-%d')='{$group['date']}'")
		or die(mysql_error());

[Channel5]

Answered my own question. It's working now. Go figure.