<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 -> <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 & Warm Regards,</font></font><div>
<font face="tahoma, sans-serif"><br></font><span style="font-family: tahoma,sans-serif;"> <font color="#999999" size="1"><u>Mayur Pimple</u></font><font color="#c0c0c0" size="1"><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: 'Trebuchet MS'; 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="http://g-ecx.images-amazon.com/images/G/01/electronics/detail-page/B001M5PZRU.Linux-logo.jpg"></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 & Warm Regards,</font></font><div><font face="tahoma, sans-serif"><br></font><span style="font-family: tahoma,sans-serif;"> <font color="#999999" size="1"><u>Mayur Pimple</u></font><font color="#c0c0c0" size="1"><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: 'Trebuchet MS'; 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="http://g-ecx.images-amazon.com/images/G/01/electronics/detail-page/B001M5PZRU.Linux-logo.jpg"></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>