Article View: pl.comp.os.linux.programowanie
Article #72179GPSPhotoTagger - sqllite - jak wyciągnąć datę i czas
From: pigobocian
Date: Tue, 12 Apr 2011 10:25
Date: Tue, 12 Apr 2011 10:25
29 lines
1986 bytes
1986 bytes
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ś? Pozdr. pigobocian.
Technical Details
Message-ID:
<4da428b4$0$2497$65785112@news.neostrada.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.glorb.com!news2.glorb.com!news-out.readnews.com!transit3.readnews.com!nx01.iad01.newshosting.com!newshosting.com!newsfeed.neostrada.pl!unt-exc-01.news.neostrada.pl!unt-spo-a-02.news.neostrada.pl!news.neostrada.pl.POSTED!not-for-mailShow 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!news2.glorb.com!news-out.readnews.com!transit3.readnews.com!nx01.iad01.newshosting.com!newshosting.com!newsfeed.neostrada.pl!unt-exc-01.news.neostrada.pl!unt-spo-a-02.news.neostrada.pl!news.neostrada.pl.POSTED!not-for-mail Date: Tue, 12 Apr 2011 12:25:56 +0200 From: pigobocian <pigobocian@wp.pl> User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.16) Gecko/20110303 Icedove/3.0.11 MIME-Version: 1.0 Newsgroups: pl.comp.os.linux.programowanie Subject: GPSPhotoTagger - sqllite - jak wyciągnąć datę i czas Lines: 29 Message-ID: <4da428b4$0$2497$65785112@news.neostrada.pl> Organization: Telekomunikacja Polska NNTP-Posting-Host: 79.185.242.37 X-Trace: 1302603956 unt-rea-a-02.news.neostrada.pl 2497 79.185.242.37:47459 X-Complaints-To: abuse@news.neostrada.pl Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit