SELECT nid, timestamp, FROM_UNIXTIME(timestamp), uid from node_revision. -Randy
On Mon, Dec 27, 2010 at 10:53 PM, Mayur pimple <[email protected]>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 [email protected] +1 970.462.7450
