<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Forum PostgreSQL - Jak spolszczyć, 1 days 21:45:45]]></title>
		<link>https://forum.postgresql.org.pl/viewtopic.php?id=2282</link>
		<description><![CDATA[Najświeższe odpowiedzi w Jak spolszczyć, 1 days 21:45:45.]]></description>
		<lastBuildDate>Fri, 22 May 2015 09:53:49 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Odp: Jak spolszczyć, 1 days 21:45:45]]></title>
			<link>https://forum.postgresql.org.pl/viewtopic.php?pid=5509#p5509</link>
			<description><![CDATA[2 metoda

select replace(replace (replace(replace (replace(replace (age(current_date,d.dzien::date)::varchar,'years','lat'),'year','rok'),'mons','miesiące'),'mon','miesiąc'),'days','dni'),'day','dzień') from generate_series('2014-01-01'::date,current_date,interval '1 day') d (dzien)]]></description>
			<author><![CDATA[dummy@example.com (c_michal)]]></author>
			<pubDate>Fri, 22 May 2015 09:53:49 +0000</pubDate>
			<guid>https://forum.postgresql.org.pl/viewtopic.php?pid=5509#p5509</guid>
		</item>
		<item>
			<title><![CDATA[Odp: Jak spolszczyć, 1 days 21:45:45]]></title>
			<link>https://forum.postgresql.org.pl/viewtopic.php?pid=5507#p5507</link>
			<description><![CDATA[np tak
select extract (year from sr_wiek)||' lat '||extract (month from sr_wiek)||' miesięcy '||extract (day from sr_wiek)||' dni' as format_interval,sr_wiek from (SELECT avg(age(current_date,'1410-07-15'::date)) as sr_wiek) d]]></description>
			<author><![CDATA[dummy@example.com (c_michal)]]></author>
			<pubDate>Fri, 22 May 2015 09:39:20 +0000</pubDate>
			<guid>https://forum.postgresql.org.pl/viewtopic.php?pid=5507#p5507</guid>
		</item>
		<item>
			<title><![CDATA[Jak spolszczyć, 1 days 21:45:45]]></title>
			<link>https://forum.postgresql.org.pl/viewtopic.php?pid=5506#p5506</link>
			<description><![CDATA[sql="SELECT "
+"avg(age(updated,zgloszenia)) as srednia " 
+"FROM public.zgloszenia_bledow";

Zwraca :
1 days 21:45:45

Jak spolszczyć czyli Days na dni]]></description>
			<author><![CDATA[dummy@example.com (gregi)]]></author>
			<pubDate>Fri, 22 May 2015 07:53:44 +0000</pubDate>
			<guid>https://forum.postgresql.org.pl/viewtopic.php?pid=5506#p5506</guid>
		</item>
	</channel>
</rss>
