{"id":90,"date":"2016-04-28T23:43:06","date_gmt":"2016-04-28T21:43:06","guid":{"rendered":"http:\/\/antek.atthost24.pl\/?p=90"},"modified":"2016-04-29T00:39:55","modified_gmt":"2016-04-28T22:39:55","slug":"ormlite-typy-danych","status":"publish","type":"post","link":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/","title":{"rendered":"SqLite &#8211; typy danych oraz zapis daty"},"content":{"rendered":"<p>W Androidzie mamy dost\u0119pn\u0105 wbudowan\u0105 relacyjn\u0105 baze danych &#8211; SqLite. Jak mo\u017cna wnioskowa\u0107 po nazwie, ta baza danych jest troch\u0119 okrojona w por\u00f3wnaniu do baz takich jak Oracle, Sybase czy\u00a0PostgreSQL.<\/p>\n<p>Dost\u0119pne typy danych w SqlLite to:<\/p>\n<ul>\n<li>INTEGER &#8211; s\u0142u\u017cy do przechowywania liczb ca\u0142kowitych; w zale\u017cno\u015bci od wielko\u015bci warto\u015bci przechowywane s\u0105 na 1, 2, 3, 4, 6 lub 8 bitach<\/li>\n<li>REAL &#8211; liczby zmiennoprzecinkowe<\/li>\n<li>TEXT- ci\u0105gi znak\u00f3w<\/li>\n<li>BLOB &#8211; dane binarne<\/li>\n<\/ul>\n<p>Jak wida\u0107 nie ma tego za wiele, lecz wystarczaj\u0105co, aby zapewni\u0107 nam wszystko czego potrzebujemy. Przynajmniej w wi\u0119kszo\u015bci wypadk\u00f3w \ud83d\ude42<\/p>\n<p>Chocia\u017c po chwili zastanowienia&#8230; gdzie jest typ Date? Jak zapisywa\u0107 dat\u0119? Tyle pyta\u0144 bez odpowiedzi&#8230; A\u017c do teraz!<\/p>\n<p>Data mo\u017ce by\u0107 przechowywana w bazie danych w jednym z trzech format\u00f3w:<\/p>\n<ul>\n<li>TEXT &#8211; data jest zapisana w formacie\u00a0ISO8601, czyli\u00a0&#8222;YYYY-MM-DD HH:MM:SS.SSS&#8221;<\/li>\n<li>REAL &#8211; data jest zapisana jako liczba dni, kt\u00f3re mine\u0142y od 24 listopada\u00a04714 r. p.n.e., czyli tak zwana <a href=\"https:\/\/en.wikipedia.org\/wiki\/Julian_day\">data Julia\u0144ska<\/a><\/li>\n<li>INTEGER &#8211; czas UNIXowy, czyli liczba milisekund, kt\u00f3re mine\u0142y od 1 stycznia 1970r.<\/li>\n<\/ul>\n<p>Do operacji na datach SqLite dostarcza 5 metod:<\/p>\n<ol>\n<li>date(timestring, &#8230;)<\/li>\n<li>time(timestring, &#8230;)<\/li>\n<li>datetime(timestring, &#8230;)<\/li>\n<li>julianday(timestring, &#8230;)<\/li>\n<li>strftime(format, timestring, &#8230;)<\/li>\n<\/ol>\n<p>Pierwsze 4 funkcje przyjmuj\u0105 string jako pierwszy argument, a nast\u0119pnie dodatkowe argumenty. Funckja\u00a0strftime przyjmuje jako pierwszy argument format daty, nast\u0119pnie warto\u015b\u0107 daty jako string oraz dodatkowe argumenty jako kolejne argumenty.<\/p>\n<p>String opisuj\u0105cy date mo\u017ce by\u0107 w jednym z poni\u017cszych format\u00f3w:<\/p>\n<ol>\n<li>YYYY-MM-DD<\/li>\n<li>YYYY-MM-DD HH:MM<\/li>\n<li>YYYY-MM-DD HH:MM:SS<\/li>\n<li>YYYY-MM-DD HH:MM:SS.SSS<\/li>\n<li>YYYY-MM-DD<strong>T<\/strong>HH:MM<\/li>\n<li>YYYY-MM-DD<strong>T<\/strong>HH:MM:SS<\/li>\n<li>YYYY-MM-DD<strong>T<\/strong>HH:MM:SS.SSS<\/li>\n<li>HH:MM<\/li>\n<li>HH:MM:SS<\/li>\n<li>HH:MM:SS.SSS<\/li>\n<li><strong>now<\/strong><\/li>\n<li>DDDDDDDDDD<\/li>\n<\/ol>\n<p>Formaty od 1 do 4 wydaj\u0105 si\u0119 by\u0107 oczywiste. W formatach 5-7 wyst\u0119puj\u0119 sta\u0142y znak <strong>T<\/strong>, kt\u00f3ry s\u0142u\u017cy jako separator daty i godziny. Formaty 8-10 s\u0142u\u017c\u0105 do przechowywania samej godziny. Format 11 to string <strong>now<\/strong>, kt\u00f3ry\u00a0odpowiada aktualnej dacie. Ostatni format jest to liczba zmiennoprzecinkowa opisuj\u0105ca date Julia\u0144sk\u0105.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>W Androidzie mamy dost\u0119pn\u0105 wbudowan\u0105 relacyjn\u0105 baze danych &#8211; SqLite. Jak mo\u017cna wnioskowa\u0107 po nazwie, ta baza danych jest troch\u0119 okrojona w por\u00f3wnaniu do baz takich jak Oracle,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,6],"tags":[5,3,4],"class_list":["post-90","post","type-post","status-publish","format-standard","hentry","category-daj-sie-poznac","category-simple-document-manager","tag-android","tag-dajsiepoznac","tag-sdm"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SqLite - typy danych oraz zapis daty - Lukasz Antkowiak&#039;s blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SqLite - typy danych oraz zapis daty - Lukasz Antkowiak&#039;s blog\" \/>\n<meta property=\"og:description\" content=\"W Androidzie mamy dost\u0119pn\u0105 wbudowan\u0105 relacyjn\u0105 baze danych &#8211; SqLite. Jak mo\u017cna wnioskowa\u0107 po nazwie, ta baza danych jest troch\u0119 okrojona w por\u00f3wnaniu do baz takich jak Oracle,...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/\" \/>\n<meta property=\"og:site_name\" content=\"Lukasz Antkowiak&#039;s blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-28T21:43:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-04-28T22:39:55+00:00\" \/>\n<meta name=\"author\" content=\"\u0141ukasz Antkowiak\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u0141ukasz Antkowiak\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/\",\"url\":\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/\",\"name\":\"SqLite - typy danych oraz zapis daty - Lukasz Antkowiak&#039;s blog\",\"isPartOf\":{\"@id\":\"https:\/\/blog.lantkowiak.pl\/#website\"},\"datePublished\":\"2016-04-28T21:43:06+00:00\",\"dateModified\":\"2016-04-28T22:39:55+00:00\",\"author\":{\"@id\":\"https:\/\/blog.lantkowiak.pl\/#\/schema\/person\/009bfc4db220c225786c59b1748ba1e6\"},\"breadcrumb\":{\"@id\":\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\/\/blog.lantkowiak.pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SqLite &#8211; typy danych oraz zapis daty\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.lantkowiak.pl\/#website\",\"url\":\"https:\/\/blog.lantkowiak.pl\/\",\"name\":\"Lukasz Antkowiak&#039;s blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.lantkowiak.pl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.lantkowiak.pl\/#\/schema\/person\/009bfc4db220c225786c59b1748ba1e6\",\"name\":\"\u0141ukasz Antkowiak\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/blog.lantkowiak.pl\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e18e2bfe319da9b5757cf7f7ae1bfecf?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e18e2bfe319da9b5757cf7f7ae1bfecf?s=96&d=monsterid&r=g\",\"caption\":\"\u0141ukasz Antkowiak\"},\"description\":\"dd\",\"url\":\"https:\/\/blog.lantkowiak.pl\/index.php\/author\/antek\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SqLite - typy danych oraz zapis daty - Lukasz Antkowiak&#039;s blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/","og_locale":"pl_PL","og_type":"article","og_title":"SqLite - typy danych oraz zapis daty - Lukasz Antkowiak&#039;s blog","og_description":"W Androidzie mamy dost\u0119pn\u0105 wbudowan\u0105 relacyjn\u0105 baze danych &#8211; SqLite. Jak mo\u017cna wnioskowa\u0107 po nazwie, ta baza danych jest troch\u0119 okrojona w por\u00f3wnaniu do baz takich jak Oracle,...","og_url":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/","og_site_name":"Lukasz Antkowiak&#039;s blog","article_published_time":"2016-04-28T21:43:06+00:00","article_modified_time":"2016-04-28T22:39:55+00:00","author":"\u0141ukasz Antkowiak","twitter_card":"summary_large_image","twitter_misc":{"Napisane przez":"\u0141ukasz Antkowiak","Szacowany czas czytania":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/","url":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/","name":"SqLite - typy danych oraz zapis daty - Lukasz Antkowiak&#039;s blog","isPartOf":{"@id":"https:\/\/blog.lantkowiak.pl\/#website"},"datePublished":"2016-04-28T21:43:06+00:00","dateModified":"2016-04-28T22:39:55+00:00","author":{"@id":"https:\/\/blog.lantkowiak.pl\/#\/schema\/person\/009bfc4db220c225786c59b1748ba1e6"},"breadcrumb":{"@id":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/04\/28\/ormlite-typy-danych\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/blog.lantkowiak.pl\/"},{"@type":"ListItem","position":2,"name":"SqLite &#8211; typy danych oraz zapis daty"}]},{"@type":"WebSite","@id":"https:\/\/blog.lantkowiak.pl\/#website","url":"https:\/\/blog.lantkowiak.pl\/","name":"Lukasz Antkowiak&#039;s blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.lantkowiak.pl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pl-PL"},{"@type":"Person","@id":"https:\/\/blog.lantkowiak.pl\/#\/schema\/person\/009bfc4db220c225786c59b1748ba1e6","name":"\u0141ukasz Antkowiak","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/blog.lantkowiak.pl\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e18e2bfe319da9b5757cf7f7ae1bfecf?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e18e2bfe319da9b5757cf7f7ae1bfecf?s=96&d=monsterid&r=g","caption":"\u0141ukasz Antkowiak"},"description":"dd","url":"https:\/\/blog.lantkowiak.pl\/index.php\/author\/antek\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/posts\/90","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/comments?post=90"}],"version-history":[{"count":10,"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/posts\/90\/revisions"}],"predecessor-version":[{"id":100,"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/posts\/90\/revisions\/100"}],"wp:attachment":[{"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/media?parent=90"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/categories?post=90"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/tags?post=90"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}