<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[Forum PostgreSQL - Jak spolszczyć, 1 days 21:45:45]]></title>
	<link rel="self" href="http://forum.postgresql.org.pl/extern.php?action=feed&amp;tid=2282&amp;type=atom"/>
	<updated>2015-05-22T09:53:49Z</updated>
	<generator>PunBB</generator>
	<id>https://forum.postgresql.org.pl/viewtopic.php?id=2282</id>
		<entry>
			<title type="html"><![CDATA[Odp: Jak spolszczyć, 1 days 21:45:45]]></title>
			<link rel="alternate" href="https://forum.postgresql.org.pl/viewtopic.php?pid=5509#p5509"/>
			<content type="html"><![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)]]></content>
			<author>
				<name><![CDATA[c_michal]]></name>
				<uri>https://forum.postgresql.org.pl/profile.php?id=627</uri>
			</author>
			<updated>2015-05-22T09:53:49Z</updated>
			<id>https://forum.postgresql.org.pl/viewtopic.php?pid=5509#p5509</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Odp: Jak spolszczyć, 1 days 21:45:45]]></title>
			<link rel="alternate" href="https://forum.postgresql.org.pl/viewtopic.php?pid=5507#p5507"/>
			<content type="html"><![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]]></content>
			<author>
				<name><![CDATA[c_michal]]></name>
				<uri>https://forum.postgresql.org.pl/profile.php?id=627</uri>
			</author>
			<updated>2015-05-22T09:39:20Z</updated>
			<id>https://forum.postgresql.org.pl/viewtopic.php?pid=5507#p5507</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Jak spolszczyć, 1 days 21:45:45]]></title>
			<link rel="alternate" href="https://forum.postgresql.org.pl/viewtopic.php?pid=5506#p5506"/>
			<content type="html"><![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]]></content>
			<author>
				<name><![CDATA[gregi]]></name>
				<uri>https://forum.postgresql.org.pl/profile.php?id=2398</uri>
			</author>
			<updated>2015-05-22T07:53:44Z</updated>
			<id>https://forum.postgresql.org.pl/viewtopic.php?pid=5506#p5506</id>
		</entry>
</feed>
