http://sqle.ru/index.php?action=history&feed=atom&title=PostgreSQL%2FDate_Timezone%2Fnow
PostgreSQL/Date Timezone/now - История изменений
2026-04-06T17:05:14Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=PostgreSQL/Date_Timezone/now&diff=4942&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:56Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=PostgreSQL/Date_Timezone/now&diff=4943&oldid=prev
Admin: 1 версия
2010-05-26T10:14:30Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Get current time for logging==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
postgres=#<br />
postgres=# create table logtable(t varchar(10), value varchar(50));<br />
CREATE TABLE<br />
postgres=#<br />
postgres=#<br />
postgres=# CREATE FUNCTION logfunc2(logtxt text) RETURNS timestamp AS $$<br />
postgres$# DECLARE<br />
postgres$# curtime timestamp;<br />
postgres$# BEGIN<br />
postgres$# curtime := "now";<br />
postgres$# INSERT INTO logtable VALUES (logtxt, curtime);<br />
postgres$# RETURN curtime;<br />
postgres$# END;<br />
postgres$# $$ LANGUAGE plpgsql;<br />
CREATE FUNCTION<br />
postgres=#<br />
postgres=# select logfunc2("123");<br />
REATE<br />
logfunc2<br />
------------------------<br />
2006-10-21 19:09:25.14<br />
(1 row)<br />
postgres=#<br />
postgres=# select * from logtable;<br />
REATE<br />
t | value<br />
-----+------------------------<br />
123 | 2006-10-21 19:09:25.14<br />
(1 row)<br />
postgres=#<br />
postgres=#<br />
postgres=# drop function logfunc2(logtxt text);<br />
DROP FUNCTION<br />
postgres=# drop table logtable;<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==now(): get current date and time==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
postgres=#<br />
postgres=# SELECT current_timestamp, now() AS timestamp;<br />
now | timestamp<br />
----------------------------+----------------------------<br />
2006-10-08 15:11:40.109-07 | 2006-10-08 15:11:40.109-07<br />
(1 row)<br />
postgres=#<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==SELECT now()==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
postgres=# SELECT now();<br />
now<br />
----------------------------<br />
2006-10-08 15:16:29.968-07<br />
(1 row)<br />
postgres=#<br />
<br />
</source></div>
Admin