[development] Fwd: node Date And Time in Drupal

[Carl Wiedemann]

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/6which
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 at 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.
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20101227/2035b371/attachment-0001.html