{"id":8025,"date":"2022-09-11T12:47:17","date_gmt":"2022-09-11T07:17:17","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/"},"modified":"2022-09-11T12:47:17","modified_gmt":"2022-09-11T07:17:17","slug":"solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/","title":{"rendered":"[Solved] convert mellisecond to date and populate in listView using cursor [duplicate]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

You are storing the dates in the SQL database as text strings, but then asking SQL to return values between to limits and expecting it to interpret those limits as dates when it hasn’t been told that they are dates and wouldn’t know how to interpret the text format as a date if it did know they were dates.<\/p>\n

Use Date.getTime() to convert the dates to long values and store those in SQL as numbers. Similarly convert your start and end times to long values, and ask SQL to return records between those values. Any time you need to convert what is stored in SQL back into a user-friendly date, use the Date(long value) constructor and pass it the number that SQL gives you.<\/p>\n<\/p><\/div>\n

<\/div>\n<\/div>\n

1<\/span> <\/p><\/div>\n<\/div>\n

[ad_2]<\/p>\n

solved convert mellisecond to date and populate in listView using cursor [duplicate] <\/p>\n","protected":false},"excerpt":{"rendered":"

[ad_1] You are storing the dates in the SQL database as text strings, but then asking SQL to return values between to limits and expecting it to interpret those limits as dates when it hasn’t been told that they are dates and wouldn’t know how to interpret the text format as a date if it … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[452,433,323,341,707],"class_list":["post-8025","post","type-post","status-publish","format-standard","hentry","category-solved","tag-android","tag-date","tag-java","tag-sql","tag-sqlite"],"yoast_head":"\n[Solved] convert mellisecond to date and populate in listView using cursor [duplicate] - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] convert mellisecond to date and populate in listView using cursor [duplicate] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] You are storing the dates in the SQL database as text strings, but then asking SQL to return values between to limits and expecting it to interpret those limits as dates when it hasn’t been told that they are dates and wouldn’t know how to interpret the text format as a date if it ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-11T07:17:17+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] convert mellisecond to date and populate in listView using cursor [duplicate]\",\"datePublished\":\"2022-09-11T07:17:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/\"},\"wordCount\":154,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"android\",\"date\",\"java\",\"sql\",\"sqlite\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/\",\"name\":\"[Solved] convert mellisecond to date and populate in listView using cursor [duplicate] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-11T07:17:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] convert mellisecond to date and populate in listView using cursor [duplicate]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] convert mellisecond to date and populate in listView using cursor [duplicate] - JassWeb","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:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] convert mellisecond to date and populate in listView using cursor [duplicate] - JassWeb","og_description":"[ad_1] You are storing the dates in the SQL database as text strings, but then asking SQL to return values between to limits and expecting it to interpret those limits as dates when it hasn’t been told that they are dates and wouldn’t know how to interpret the text format as a date if it ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/","og_site_name":"JassWeb","article_published_time":"2022-09-11T07:17:17+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] convert mellisecond to date and populate in listView using cursor [duplicate]","datePublished":"2022-09-11T07:17:17+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/"},"wordCount":154,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["android","date","java","sql","sqlite"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/","url":"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/","name":"[Solved] convert mellisecond to date and populate in listView using cursor [duplicate] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-11T07:17:17+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-convert-mellisecond-to-date-and-populate-in-listview-using-cursor-duplicate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] convert mellisecond to date and populate in listView using cursor [duplicate]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/8025","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=8025"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/8025\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=8025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=8025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=8025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}