Article View: pl.comp.bazy-danych
Article #183373Re: Data w bazie danych w postaci liczby
From: Handheld
Date: Thu, 16 Jul 2009 14:20
Date: Thu, 16 Jul 2009 14:20
22 lines
2080 bytes
2080 bytes
On 16 Lip, 15:41, "A.L.E.C" <al...@poczta.onet.pl> wrote: > Handheld wrote: > >> To może być ilość dni od 28.12.1800 r. > > > funkcja date daje mi datę, z tym że z księżyca. > > Jestem na etapie szukania 'klucza' którym potraktuje zawartość tego > > pola, by mi dawał 'sensowną' datę. > > Na postgresie zapytanie: > > select '1800-12-28'::date + interval '76038 days' > > zwraca > > '2009-03-05' > > -- > Aleksander 'A.L.E.C' Machniakhttp://alec.plgg:2275252 > LAN Management System Developerhttp://lms.org.pl > Roundcube Webmail Project Developerhttp://roundcube.net Dzięki, zaraz sobie sprawdzę.
Technical Details
Message-ID:
<0bbbf9c3-c74e-49fe-a74f-1010a0555610@h2g2000yqg.googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.glorb.com!postnews.google.com!h2g2000yqg.googlegroups.com!not-for-mailReferences:
<38333593-3d88-4298-a2d5-0cb053ead194@24g2000yqm.googlegroups.com> <bea199fa-7640-4c06-8ce4-b3b494efc73e@18g2000yqa.googlegroups.com> <72a911cc-37bb-49f1-98d8-31c55371cf0b@n11g2000yqb.googlegroups.com> <h3n11o$d14$1@news.onet.pl> <e8436c60-65d6-4126-a517-013ff57450e9@y7g2000yqa.googlegroups.com> <h3nahf$7cd$1@news.onet.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.glorb.com!postnews.google.com!h2g2000yqg.googlegroups.com!not-for-mail From: Handheld <rzeczy.rozne@gmail.com> Newsgroups: pl.comp.bazy-danych Subject: Re: Data w bazie danych w postaci liczby Date: Thu, 16 Jul 2009 07:20:46 -0700 (PDT) Organization: http://groups.google.com Lines: 23 Message-ID: <0bbbf9c3-c74e-49fe-a74f-1010a0555610@h2g2000yqg.googlegroups.com> References: <38333593-3d88-4298-a2d5-0cb053ead194@24g2000yqm.googlegroups.com> <bea199fa-7640-4c06-8ce4-b3b494efc73e@18g2000yqa.googlegroups.com> <72a911cc-37bb-49f1-98d8-31c55371cf0b@n11g2000yqb.googlegroups.com> <h3n11o$d14$1@news.onet.pl> <e8436c60-65d6-4126-a517-013ff57450e9@y7g2000yqa.googlegroups.com> <h3nahf$7cd$1@news.onet.pl> NNTP-Posting-Host: 193.238.18.158 Mime-Version: 1.0 X-Trace: posting.google.com 1247754047 4115 127.0.0.1 (16 Jul 2009 14:20:47 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 16 Jul 2009 14:20:47 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: h2g2000yqg.googlegroups.com; posting-host=193.238.18.158; posting-account=MNwG2goAAAD7JGVXF2xI9-b1nDj62kMT User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/530.5 (KHTML, like Gecko) Chrome/2.0.172.33 Safari/530.5,gzip(gfe),gzip(gfe) Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit