[development] Fwd: node Date And Time in Drupal

[Mayur pimple]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20101228/865e0485/attachment.html