fetch the date from timestamp

[roshanjameer]

hi,

i have a mysql table with 3 fields

1.id 2.time 3.approved

values

1 1181237691 0
2 1181237703 0
3 1181237711 0

i want to fetch the distinct dates from this timestamp values using select statement.
i want to display like this
1 2007-06-07

second thing i want to update the approved value=1 where these distinct dates are equal to the above timestamps

any of your help will be surely appreciated.
thanks
mrjameer

[stolzyboy]

SELECT DATE_FORMAT(time, '%Y-%m-%d') as mydate

[bradgrafelman]

Any reason you're storing the timestamps as Unix timestamp integers instead of using a DATETIME column?