[development] Fwd: node Date And Time in Drupal

Hi i want date and time of node from database. in database node_revision table 1) nid 2) timestamp 3) uid and other filed Timestamps value is in database =1292839748 but i want in this format -> Mon, 12/27/2010 my question is how write select query so that i can get this date and time -- Thanks & Warm Regards, *Mayur Pimple** | Raintek Solution * Skype: mayur.pimple Mobile: 9270367824 www.mayurpimple.blogspot.com We are the Representatives of the Modern World of Evolution. -- Thanks & Warm Regards, *Mayur Pimple** | Raintek Solution * Skype: mayur.pimple Mobile: 9270367824 www.mayurpimple.blogspot.com We are the Representatives of the Modern World of Evolution.