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,