SELECT nid, timestamp, FROM_UNIXTIME(timestamp), uid from node_revision.<br><br>-Randy<br><br><div class="gmail_quote">On Mon, Dec 27, 2010 at 10:53 PM, Mayur pimple <span dir="ltr">&lt;<a href="mailto:mayurpimple12@gmail.com">mayurpimple12@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><br><div class="gmail_quote"><br><br>Hi <br><br>i want date and time of node from database.<br>
in database node_revision table<br clear="all"><br>1) nid<br>2) timestamp<br>3) uid<br>and other filed<br><br>Timestamps value is in database =<span dir="ltr"><span dir="ltr" title="Call this phone number in India with Skype: +911292839748"><span><span>1292839748</span></span><span> </span></span></span><br>


but i want in this format -&gt;  <span>Mon, 12/27/2010</span><br><br>my question is how write select query so that i can get this date and time<br>-- <br><font face="tahoma, sans-serif"><font color="#999999">Thanks &amp; Warm Regards,</font></font><div>


<font face="tahoma, sans-serif"><br></font><span style="font-family: tahoma,sans-serif;">  <font size="1" color="#999999"><u>Mayur Pimple</u></font><font size="1" color="#c0c0c0"><u> | Raintek Solution<br></u></font></span> <span style="color: rgb(192, 192, 192);"> </span><font style="color: rgb(192, 192, 192);" size="2">Skype: mayur.pimple</font><br>


<div><font face="tahoma, sans-serif">  <span style="font-family: &#39;Trebuchet MS&#39;; font-size: 11px; border-collapse: collapse; color: rgb(128, 128, 128);">Mobile: </span><font color="#999999">9270367824</font><br> <font size="1"> <a href="http://www.mayurpimple.blogspot.com" target="_blank"><font color="#999999">www.mayurpimple.blogspot.com</font></a></font><br>


<span style="color: rgb(255, 102, 0);"><br></span></font></div><div><font face="tahoma, sans-serif"><span style="color: rgb(255, 102, 0);">                         <img src=""></span>      <br>

<font color="#ff0000">We are the Representatives of the Modern World of Evolution</font><font color="#ff6600">. </font></font></div></div><div><font face="tahoma, sans-serif"><font color="#ff6600"><br></font></font></div>


<br>
</div><br><br clear="all"><br>-- <br><font face="tahoma, sans-serif"><font color="#999999">Thanks &amp; Warm Regards,</font></font><div><font face="tahoma, sans-serif"><br></font><span style="font-family: tahoma,sans-serif;">  <font size="1" color="#999999"><u>Mayur Pimple</u></font><font size="1" color="#c0c0c0"><u> | Raintek Solution<br>

</u></font></span> <span style="color: rgb(192, 192, 192);"> </span><font style="color: rgb(192, 192, 192);" size="2">Skype: mayur.pimple</font><br><div><font face="tahoma, sans-serif">  <span style="font-family: &#39;Trebuchet MS&#39;; font-size: 11px; border-collapse: collapse; color: rgb(128, 128, 128);">Mobile: </span><font color="#999999">9270367824</font><br>

 <font size="1"> <a href="http://www.mayurpimple.blogspot.com" target="_blank"><font color="#999999">www.mayurpimple.blogspot.com</font></a></font><br><span style="color: rgb(255, 102, 0);"><br></span></font></div><div><font face="tahoma, sans-serif"><span style="color: rgb(255, 102, 0);">                         <img src=""></span>      <br>

<font color="#ff0000">We are the Representatives of the Modern World of Evolution</font><font color="#ff6600">. </font></font></div></div><div><font face="tahoma, sans-serif"><font color="#ff6600"><br></font></font></div>

<br>
</blockquote></div><br><br clear="all"><br>-- <br>Randy Fay<br>Drupal Module and Site Development<br><a href="mailto:randy@randyfay.com">randy@randyfay.com</a><br>+1  970.462.7450<br><br>