From: Devrim GUNDUZ (devrim@gunduz.org)
Date: Thu 31 Jul 2003 - 19:58:27 EEST
Merhabalar,
On Thu, 31 Jul 2003, M.Ali VARDAR wrote:
> Daha evvelki postgresql surumunda now()-8 diyerek 8 gun oncesini
> alabiliyordum. Bu konuda bilgi olan varmę acaba
Asagidaki ornekler sanirim isinize yarar:
=====
regression=# select now() - '8 days'::interval AS aliniz;
aliniz
-------------------------------
2003-07-23 11:57:23.730083-05
(1 row)
regression=# select now() - '8 hours'::interval AS aliniz;
aliniz
-------------------------------
2003-07-31 03:57:32.881772-05
(1 row)
regression=# select now() - '8 minutes'::interval AS aliniz;
aliniz
-------------------------------
2003-07-31 11:49:38.785767-05
(1 row)
regression=# SELECT version();
version
-----------------------------------------------------------------
PostgreSQL 7.3.4 on i386-redhat-linux-gnu, compiled by GCC 2.96
(1 row)
regression=#
====================
7.3.3 surumunde de calisti.
Saygilar,
-- Devrim GUNDUZ devrim@gunduz.org devrim.gunduz@linux.org.tr http://www.tdmsoft.com http://www.gunduz.org