🚀 go-pugleaf

W dniu 2011-04-12 14:32, bofh@nano.pl pisze:
> 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?
>
>
Ustawienia urządzenia (chyba wszystkie bo mam ich kilka):
Zapis co 3-5 sekundy, stop przy 3km/h