If you are using MySQL, you could use some of the date functions provided http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html However, since it is better to program to an interface rather than an implementation, consider instead selecting the timestamps directly and using Drupal's date_format function http://api.drupal.org/api/drupal/includes--common.inc/function/format_date/6... will provide user-based timezone support. You may also be interested in the date and date_api modules http://drupal.org/project/date 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.