Article View: pl.comp.lang.php
Article #870Re: dzia³ania na datach
From: Michal Sajdak
Date: Fri, 24 Aug 2001 11:02
Date: Fri, 24 Aug 2001 11:02
13 lines
1411 bytes
1411 bytes
In article <9m5b9n$6s0$1@news.tpi.pl>, Robert Chojnacki wrote:
>Dostajê z bazy daty w postaci:
>
>20010801 (rok-miesi±c-dzieñ).
>Chodzi mi uzyskanie ró¿nicy pomiêdzy dwiema datami, która bêdzie wyra¿ona w
>dniach.
jesli potrzebuje - robie to w postgresie:
SELECT date_part('days', NOW() - end_date) FROM tabela;
--
Michal Sajdak --> xterm --> LinuxNews Team.
GPG: http://urtica.linuxnews.pl/~xterm/key/
[ http://hardware.linuxnews.pl/ ] - [ http://linuxnews.pl/ ]
Technical Details
Message-ID:
<slrn9ocddu.196v.sajdakm@demon.viii-lo.krakow.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!mat.uni.torun.pl!pcmedia.com.pl!news.man.szczecin.pl!news.mega.net.pl!news.task.gda.pl!newsfeed.tpinternet.pl!news.nask.pl!newsfeed.formus.pl!news.cyf-kr.edu.pl!sajdakmReferences:
<9m5b9n$6s0$1@news.tpi.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!mat.uni.torun.pl!pcmedia.com.pl!news.man.szczecin.pl!news.mega.net.pl!news.task.gda.pl!newsfeed.tpinternet.pl!news.nask.pl!newsfeed.formus.pl!news.cyf-kr.edu.pl!sajdakm From: sajdakm@demon.viii-lo.krakow.pl (Michal Sajdak) Newsgroups: pl.comp.lang.php Subject: Re: dzia³ania na datach Date: Fri, 24 Aug 2001 11:02:25 +0000 (UTC) Organization: Academic Computer Center CYFRONET AGH Lines: 13 Message-ID: <slrn9ocddu.196v.sajdakm@demon.viii-lo.krakow.pl> References: <9m5b9n$6s0$1@news.tpi.pl> NNTP-Posting-Host: demon.viii-lo.krakow.pl Mime-Version: 1.0 X-Trace: info.cyf-kr.edu.pl 998650945 16744 195.150.148.1 (24 Aug 2001 11:02:25 GMT) X-Complaints-To: news@cyf-kr.edu.pl NNTP-Posting-Date: Fri, 24 Aug 2001 11:02:25 +0000 (UTC) User-Agent: slrn/0.9.6.3 (FreeBSD) Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit