SELECT nid, timestamp, FROM_UNIXTIME(timestamp), uid from node_revision. -Randy On Mon, Dec 27, 2010 at 10:53 PM, Mayur pimple <mayurpimple12@gmail.com>wrote:
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.
-- Randy Fay Drupal Module and Site Development randy@randyfay.com +1 970.462.7450