fetch the date from timestamp

[mrjameer]

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

[per1os]

www.php.net/date

www.php.net/strtotime

 

$date = date('Y-m-d', $timefromdb);
$dateto = "2007-06-07";
$datetocheck = strtotime($dateto);

$sql = "UPDATE table_name SET value = 1 WHERE time = " . $datetocheck;