Re: GPSPhotoTagger - sqllite - jak wyciągnąć datę i czas - Article 72180 - go-pugleaf

Article View: pl.comp.os.linux.programowanie

Article #72180

Back to pl.comp.os.linux.programowanie Previous Next

Re: GPSPhotoTagger - sqllite - jak wyciągnąć datę i czas

#72180

From: bofh
Date: Tue, 12 Apr 2011 12:32

34 lines
2193 bytes

On 12.04.2011 12:25, pigobocian wrote:
> Witam.
> Program wymieniony w temacie tworzy po odczytaniu danych z GPS'a pliki
> ITM, które są zwykłymi ZIP'ami. Wewnątrz jest plik z bazą SQLITE.
> Dane typu latitude, longtitude, altitude są zapisane w sposób
> czytelny. Natomiast data i czas każdego pomiaru to jakieś długie liczby.
> Eksport z tabeli wygląda tak:
> 
> "fID","fZero","fGPSTime1","fGPSTime2","fGPSSpeed"
> "1","0","30114423","67089792","0.0"
> "2","0","30114423","467089792","11.0"
> "3","0","30114423","517089792","10.0"
> "4","0","30114423","567089792","2.0"
> "5","0","30114423","707089792","12.0"
> "6","0","30114423","757089792","14.0"
> "7","0","30114423","807089792","13.0"
> "8","0","30114423","987089792","0.0"
> "9","0","30114423","1087089792","5.0"
> "10","0","30114423","1147089792","6.0"
> "11","0","30114423","1197089792","8.0"
> 
> Jak przekonwertować pola fGPSTime1 i fGPSTime2 na datę i czas?
> 
> Funkcje sqlite typu date(...), time(...), datetime(...) dla
> tych kolumn zwracają bzdury.
> 
> Podpowie ktoś?

A co ile mniej więcej robiłeś te pomiary?


-- 
wer <",,)~~
http://szumofob.eu

Technical Details

Message-ID: <io1gog$mmt$1@node2.news.atman.pl>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.supermedia.pl!news.nask.pl!news.nask.org.pl!newsfeed2.atman.pl!newsfeed.atman.pl!.POSTED!not-for-mail

References: <4da428b4$0$2497$65785112@news.neostrada.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.supermedia.pl!news.nask.pl!news.nask.org.pl!newsfeed2.atman.pl!newsfeed.atman.pl!.POSTED!not-for-mail
From: "bofh@nano.pl" <bofh@nano.pl>
Newsgroups: pl.comp.os.linux.programowanie
Subject: Re: GPSPhotoTagger - sqllite - jak
 wyciągnąć datę i czas
Date: Tue, 12 Apr 2011 14:32:16 +0200
Organization: ATMAN - ATM S.A.
Lines: 34
Message-ID: <io1gog$mmt$1@node2.news.atman.pl>
References: <4da428b4$0$2497$65785112@news.neostrada.pl>
NNTP-Posting-Host: 195.78.66.5
Mime-Version: 1.0
X-Trace: node2.news.atman.pl 1302611536 23261 195.78.66.5 (12 Apr 2011 12:32:16 GMT)
X-Complaints-To: usenet@atman.pl
NNTP-Posting-Date: Tue, 12 Apr 2011 12:32:16 +0000 (UTC)
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.10) Gecko/20100624 Mandriva/3.0.5-0.1mdv2009.1 (2009.1) Thunderbird/3.0.5
In-Reply-To: <4da428b4$0$2497$65785112@news.neostrada.pl>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message