Как узнать текущую дату и время (SQL) | Ник Курковntent="WordPress 2.3.3" />  <link rel="stylesheet" href="http://kurkov.biz/blog/wp-content/themes/default/style.css" type="text/css" media="screen" /> <link rel="alternate" type="application/rss+xml" title="Ник Курков RSS Feed" href="http://kurkov.biz/blog/feed" /> <link rel="pingback" href="http://kurkov.biz/blog/xmlrpc.php" /> <style type="text/css" media="screen"> #page { background: url("http://kurkov.biz/blog/wp-content/themes/default/images/kubrickbgwide.jpg") repeat-y top; border: none; } </style> <link rel="EditURI" type="application/rsd+xml" title="RSD" href="http://kurkov.biz/blog/xmlrpc.php?rsd" /> <link rel="wlwmanifest" type="application/wlwmanifest+xml" href="http://kurkov.biz/blog/wp-includes/wlwmanifest.xml" /> <script type='text/javascript' src='http://kurkov.biz/blog/wp-includes/js/prototype.js?ver=1.5.1.1'></script>  <meta name="description" content="Вот как узнать текущую дату и время в SQL: CURRENT_TIMESTAMP" />   <link rel="stylesheet" type="text/css" href="http://kurkov.biz/blog/wp-content/plugins/contactforms/styling/cforms.css" /> <script type="text/javascript" src="http://kurkov.biz/blog/wp-content/plugins/contactforms/js/cforms.js"></script>   <link rel="stylesheet" href="http://kurkov.biz/blog/wp-content/plugins/pagenavi/pagenavi-css.css" type="text/css" media="screen" />  <script type="text/javascript" src="http://kurkov.biz/blog/wp-content/plugins/podpress/podpress.js"></script> <script type="text/javascript"></script> <link rel="stylesheet" href="http://kurkov.biz/blog/wp-content/plugins/podpress/podpress.css" type="text/css" /> <script type="text/javascript" src="http://kurkov.biz/blog/index.php?ak_action=wp_grins_js"></script> <style type="text/css"> #wp_grins img { cursor: pointer; } </style>  </head> <body> <div id="page"> <div id="header"> <div id="headerimg"> <h1><a href="http://kurkov.biz/blog/">Ник Курков</a></h1> <div class="description">Думаем-придумаем</div> </div> </div> <hr /> <div id="content" class="widecolumn"> <div class="navigation"> <div class="alignleft">« <a href="http://kurkov.biz/blog/kuda-katitsya-mir">Куда катится мир</a></div> <div class="alignright"><a href="http://kurkov.biz/blog/kak-uznat-imya-kompyutera-hostname-klienta-vypolnivshego-zapros-sql">Как узнать имя компьютера (hostname) клиента, выполнившего запрос (SQL)</a> »</div> </div> <div class="post" id="post-143"> <h2><a href="http://kurkov.biz/blog/kak-uznat-tekushhuyu-datu-i-vremya-sql" rel="bookmark" title="Permanent Link: Как узнать текущую дату и время (SQL)">Как узнать текущую дату и время (SQL)</a></h2> <div class="entry"> <p>Вот как узнать текущую дату и время в SQL:</p> <p><strong>CURRENT_TIMESTAMP</strong></p> <div class="addzakl"><a rel="nofollow" href="http://www.google.com/bookmarks/mark?op=edit&bkmk=http://kurkov.biz/blog/kak-uznat-tekushhuyu-datu-i-vremya-sql&title=%D0%9A%D0%B0%D0%BA+%D1%83%D0%B7%D0%BD%D0%B0%D1%82%D1%8C+%D1%82%D0%B5%D0%BA%D1%83%D1%89%D1%83%D1%8E+%D0%B4%D0%B0%D1%82%D1%83+%D0%B8+%D0%B2%D1%80%D0%B5%D0%BC%D1%8F+%28SQL%29+-+%D0%9D%D0%B8%D0%BA+%D0%9A%D1%83%D1%80%D0%BA%D0%BE%D0%B2"><img border="0" title="google.com" alt="google.com" src="http://kurkov.biz/blog/wp-content/plugins/addzakl/images/google_bmarks.gif" width="16" height="16" /></a> <a rel="nofollow" href="http://bobrdobr.ru/addext.html?url=http://kurkov.biz/blog/kak-uznat-tekushhuyu-datu-i-vremya-sql&title=%D0%9A%D0%B0%D0%BA+%D1%83%D0%B7%D0%BD%D0%B0%D1%82%D1%8C+%D1%82%D0%B5%D0%BA%D1%83%D1%89%D1%83%D1%8E+%D0%B4%D0%B0%D1%82%D1%83+%D0%B8+%D0%B2%D1%80%D0%B5%D0%BC%D1%8F+%28SQL%29+-+%D0%9D%D0%B8%D0%BA+%D0%9A%D1%83%D1%80%D0%BA%D0%BE%D0%B2"><img border="0" title="bobrdobr.ru" alt="bobrdobr.ru" src="http://kurkov.biz/blog/wp-content/plugins/addzakl/images/bobrdobr.gif" width="16" height="16" /></a> <a rel="nofollow" href="http://del.icio.us/post?url=http://kurkov.biz/blog/kak-uznat-tekushhuyu-datu-i-vremya-sql&title=%D0%9A%D0%B0%D0%BA+%D1%83%D0%B7%D0%BD%D0%B0%D1%82%D1%8C+%D1%82%D0%B5%D0%BA%D1%83%D1%89%D1%83%D1%8E+%D0%B4%D0%B0%D1%82%D1%83+%D0%B8+%D0%B2%D1%80%D0%B5%D0%BC%D1%8F+%28SQL%29+-+%D0%9D%D0%B8%D0%BA+%D0%9A%D1%83%D1%80%D0%BA%D0%BE%D0%B2"><img border="0" title="del.icio.us" alt="del.icio.us" src="http://kurkov.biz/blog/wp-content/plugins/addzakl/images/delicious.gif" width="16" height="16" /></a> <a rel="nofollow" href="http://www.technorati.com/faves?add=http://kurkov.biz/blog/kak-uznat-tekushhuyu-datu-i-vremya-sql"><img border="0" title="technorati.com" alt="technorati.com" src="http://kurkov.biz/blog/wp-content/plugins/addzakl/images/technorati.gif" /></a> <a rel="nofollow" href="http://www.linkstore.ru/servlet/LinkStore?a=add&url=http://kurkov.biz/blog/kak-uznat-tekushhuyu-datu-i-vremya-sql&title=%D0%9A%D0%B0%D0%BA+%D1%83%D0%B7%D0%BD%D0%B0%D1%82%D1%8C+%D1%82%D0%B5%D0%BA%D1%83%D1%89%D1%83%D1%8E+%D0%B4%D0%B0%D1%82%D1%83+%D0%B8+%D0%B2%D1%80%D0%B5%D0%BC%D1%8F+%28SQL%29+-+%D0%9D%D0%B8%D0%BA+%D0%9A%D1%83%D1%80%D0%BA%D0%BE%D0%B2"><img border="0" title="linkstore.ru" alt="linkstore.ru" src="http://kurkov.biz/blog/wp-content/plugins/addzakl/images/linkstore.gif" width="16" height="16" /></a> <a rel="nofollow" href="http://news2.ru/add_story.php?url=http://kurkov.biz/blog/kak-uznat-tekushhuyu-datu-i-vremya-sql"><img border="0" title="news2.ru" alt="news2.ru" src="http://kurkov.biz/blog/wp-content/plugins/addzakl/images/news2-ru.gif" /></a> <a rel="nofollow" href="http://rumarkz.ru/bookmarks/?action=add&popup=1&address=http://kurkov.biz/blog/kak-uznat-tekushhuyu-datu-i-vremya-sql&title=%D0%9A%D0%B0%D0%BA+%D1%83%D0%B7%D0%BD%D0%B0%D1%82%D1%8C+%D1%82%D0%B5%D0%BA%D1%83%D1%89%D1%83%D1%8E+%D0%B4%D0%B0%D1%82%D1%83+%D0%B8+%D0%B2%D1%80%D0%B5%D0%BC%D1%8F+%28SQL%29+-+%D0%9D%D0%B8%D0%BA+%D0%9A%D1%83%D1%80%D0%BA%D0%BE%D0%B2"><img border="0" title="rumarkz.ru" alt="rumarkz.ru" src="http://kurkov.biz/blog/wp-content/plugins/addzakl/images/rumark.gif" width="16" height="16" /></a> <a rel="nofollow" href="http://memori.ru/link/?sm=1&u_data[url]=http://kurkov.biz/blog/kak-uznat-tekushhuyu-datu-i-vremya-sql&u_data[name]=%D0%9A%D0%B0%D0%BA+%D1%83%D0%B7%D0%BD%D0%B0%D1%82%D1%8C+%D1%82%D0%B5%D0%BA%D1%83%D1%89%D1%83%D1%8E+%D0%B4%D0%B0%D1%82%D1%83+%D0%B8+%D0%B2%D1%80%D0%B5%D0%BC%D1%8F+%28SQL%29+-+%D0%9D%D0%B8%D0%BA+%D0%9A%D1%83%D1%80%D0%BA%D0%BE%D0%B2"><img border="0" title="memori.ru" alt="memori.ru" src="http://kurkov.biz/blog/wp-content/plugins/addzakl/images/memori.gif" width="16" height="16" /></a> <a rel="nofollow" href="http://moemesto.ru/post.php?url=http://kurkov.biz/blog/kak-uznat-tekushhuyu-datu-i-vremya-sql&title=%D0%9A%D0%B0%D0%BA+%D1%83%D0%B7%D0%BD%D0%B0%D1%82%D1%8C+%D1%82%D0%B5%D0%BA%D1%83%D1%89%D1%83%D1%8E+%D0%B4%D0%B0%D1%82%D1%83+%D0%B8+%D0%B2%D1%80%D0%B5%D0%BC%D1%8F+%28SQL%29+-+%D0%9D%D0%B8%D0%BA+%D0%9A%D1%83%D1%80%D0%BA%D0%BE%D0%B2"><img border="0" title="moemesto.ru" alt="moemesto.ru" src="http://kurkov.biz/blog/wp-content/plugins/addzakl/images/moemesto.gif" width="16" height="16" /></a></div> <p class="postmetadata alt"> <small> This entry was posted on понедельник, мая 12, 2008 at 17:28 and is filed under <a href="http://kurkov.biz/blog/category/sql" title="View all posts in SQL" rel="category tag">SQL</a>, <a href="http://kurkov.biz/blog/category/dlya-sebya" title="View all posts in для себя" rel="category tag">для себя</a>. You can follow any responses to this entry through the <a href='http://kurkov.biz/blog/kak-uznat-tekushhuyu-datu-i-vremya-sql/feed'>RSS 2.0</a> feed. You can <a href="#respond">leave a response</a>, or <a href="http://kurkov.biz/blog/kak-uznat-tekushhuyu-datu-i-vremya-sql/trackback" rel="trackback">trackback</a> from your own site. </small> </p> </div> </div>   <h3 id="respond">Leave a Reply</h3> <form action="http://kurkov.biz/blog/wp-comments-post.php" method="post" id="commentform"> <p><input type="text" name="author" id="author" value="" size="22" tabindex="1" /> <label for="author"><small>Name (required)</small></label></p> <p><input type="text" name="email" id="email" value="" size="22" tabindex="2" /> <label for="email"><small>Mail (will not be published) (required)</small></label></p> <p><input type="text" name="url" id="url" value="" size="22" tabindex="3" /> <label for="url"><small>Website</small></label></p>  <p><textarea name="comment" id="comment" cols="100%" rows="10" tabindex="4"></textarea></p> <p><input name="submit" type="submit" id="submit" tabindex="5" value="Submit Comment" /> <input type="hidden" name="comment_post_ID" value="143" /> </p> <div class="secimgdiv" id="2f399030a48ddiv"> <p><input type="text" name="2f399030a48d" id="2f399030a48d" size="6" maxlength="4" tabindex="4" /> <label for="2f399030a48d"><img src="/blog/index.php?image=1231303442" width="140" height="25" alt="Введите этот защитный код: нижние символы" align="absbottom" /> <small>Введите <strong>нижние</strong> символы</small></label> </p> </div> <script language="JavaScript" type="text/javascript"> var urlinput = document.getElementById("url"); var submitp = urlinput.parentNode; var substitution2 = document.getElementById("2f399030a48ddiv"); submitp.appendChild(substitution2, urlinput); </script> <p style="clear: both;" class="subscribe-to-comments"> <input type="checkbox" name="subscribe" id="subscribe" value="subscribe" style="width: auto;" /> <label for="subscribe">Notify me of followup comments via e-mail</label> </p> </form> </div> <hr /> <div id="footer"> </div> </div> </body> </html>