{"id":3883,"date":"2019-06-28T21:23:58","date_gmt":"2019-06-28T15:53:58","guid":{"rendered":"https:\/\/pynative.com\/?p=3883"},"modified":"2021-03-09T10:57:35","modified_gmt":"2021-03-09T05:27:35","slug":"python-sqlite-date-and-datetime","status":"publish","type":"post","link":"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/","title":{"rendered":"Python SQLite working with Date and DateTime"},"content":{"rendered":"\n<p>This lesson demonstrates how to work with SQLite date and timestamp types in Python and vice-versa. Most of the time, we need to insert Python <code>date<\/code> or <code>DateTime<\/code> value into an SQLite table. Also, we need to read the SQLite date and timestamp values stored in the SQLite3 database and convert them into Python <code>date<\/code> and <code>DateTime<\/code> types.<\/p>\n\n\n\n<div class=\"wp-block-columns sectionpy has-black-color has-text-color has-background is-layout-flex wp-container-core-columns-is-layout-1 wp-block-columns-is-layout-flex\" style=\"background-color:#fff7ed\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Also Read<\/strong>:<\/p>\n\n\n\n<ul><li>Solve&nbsp;<a href=\"https:\/\/pynative.com\/python-database-programming-exercise-with-solution\/\">Python SQLite Exercise<\/a><\/li><li>Read&nbsp;<a href=\"https:\/\/pynative.com\/python-sqlite\/\">Python SQLite Tutorial (Complete Guide)<\/a><\/li><\/ul>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-yoast-seo-table-of-contents yoast-table-of-contents\"><h2>Table of contents<\/h2><ul><li><a href=\"#h-prerequisites\" data-level=\"2\">Prerequisites<\/a><\/li><li><a href=\"#h-python-example-to-insert-retrieve-datetime-from-sqlite-table\" data-level=\"2\">Python example to insert\/Retrieve DateTime from SQLite table<\/a><\/li><li><a href=\"#h-next-steps\" data-level=\"2\">Next Steps:<\/a><\/li><\/ul><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-prerequisites\">Prerequisites<\/h2>\n\n\n\n<p>Before executing the following program, please make sure you have an SQLite table with a timestamp as a column from which you want to retrieve\/insert data.<\/p>\n\n\n\n<p>For this lesson, I am using the &#8216;new_developers&#8217; table present in my SQLite database.<\/p>\n\n\n\n<p>If a table is not present in your SQLite database, then please refer to the following articles: &#8211;<\/p>\n\n\n\n<ul><li><a href=\"https:\/\/pynative.com\/python-sqlite\/#h-create-sqlite-table-from-python\">Create SQLite table from Python<\/a>.<\/li><li><a href=\"https:\/\/pynative.com\/python-sqlite-insert-into-table\/\">Insert data into SQLite Table from Python<\/a><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-python-example-to-insert-retrieve-datetime-from-sqlite-table\">Python example to insert\/Retrieve DateTime from SQLite table<\/h2>\n\n\n\n<p>In a usual scenario, when you execute the insert query with the DateTime object, the Python sqlite3 module converts it into a string format instead of an actual DateTime. And when you run a SELECT query from Python to read DateTime values from SQLite table, the sqlite3 module will convert it into a string object. Let&#8217;s understand this scenario with a simple example.<\/p>\n\n\n<div class=\"hljstoolbar\"><pre id=\"code1\"  id=\"norun\" class=\"wp-block-code language-python\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"Python\" data-shcb-language-slug=\"python\"><span><code class=\"hljs language-python\"><span class=\"hljs-keyword\">import<\/span> datetime\n<span class=\"hljs-keyword\">import<\/span> sqlite3\n\n<span class=\"hljs-function\"><span class=\"hljs-keyword\">def<\/span> <span class=\"hljs-title\">addDeveloper<\/span><span class=\"hljs-params\">(id, name, joiningDate)<\/span>:<\/span>\n    <span class=\"hljs-keyword\">try<\/span>:\n        sqliteConnection = sqlite3.connect(<span class=\"hljs-string\">'SQLite_Python.db'<\/span>)\n        cursor = sqliteConnection.cursor()\n        print(<span class=\"hljs-string\">\"Connected to SQLite\"<\/span>)\n\n        sqlite_create_table_query = <span class=\"hljs-string\">'''CREATE TABLE new_developers (\n                                       id INTEGER PRIMARY KEY,\n                                       name TEXT NOT NULL,\n                                       joiningDate timestamp);'''<\/span>\n\n        cursor = sqliteConnection.cursor()\n        cursor.execute(sqlite_create_table_query)\n\n        <span class=\"hljs-comment\"># insert developer detail<\/span>\n        sqlite_insert_with_param = <span class=\"hljs-string\">\"\"\"INSERT INTO 'new_developers'\n                          ('id', 'name', 'joiningDate') \n                          VALUES (?, ?, ?);\"\"\"<\/span>\n\n        data_tuple = (id, name, joiningDate)\n        cursor.execute(sqlite_insert_with_param, data_tuple)\n        sqliteConnection.commit()\n        print(<span class=\"hljs-string\">\"Developer added successfully \\n\"<\/span>)\n\n        <span class=\"hljs-comment\"># get developer detail<\/span>\n        sqlite_select_query = <span class=\"hljs-string\">\"\"\"SELECT name, joiningDate from new_developers where id = ?\"\"\"<\/span>\n        cursor.execute(sqlite_select_query, (<span class=\"hljs-number\">1<\/span>,))\n        records = cursor.fetchall()\n\n        <span class=\"hljs-keyword\">for<\/span> row <span class=\"hljs-keyword\">in<\/span> records:\n            developer = row&#91;<span class=\"hljs-number\">0<\/span>]\n            joining_Date = row&#91;<span class=\"hljs-number\">1<\/span>]\n            print(developer, <span class=\"hljs-string\">\" joined on\"<\/span>, joiningDate)\n            print(<span class=\"hljs-string\">\"joining date type is\"<\/span>, type(joining_Date))\n\n        cursor.close()\n\n    <span class=\"hljs-keyword\">except<\/span> sqlite3.Error <span class=\"hljs-keyword\">as<\/span> error:\n        print(<span class=\"hljs-string\">\"Error while working with SQLite\"<\/span>, error)\n    <span class=\"hljs-keyword\">finally<\/span>:\n        <span class=\"hljs-keyword\">if<\/span> sqliteConnection:\n            sqliteConnection.close()\n            print(<span class=\"hljs-string\">\"sqlite connection is closed\"<\/span>)\n\naddDeveloper(<span class=\"hljs-number\">1<\/span>, <span class=\"hljs-string\">'Mark'<\/span>, datetime.datetime.now())\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Python<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">python<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><button class=\"hljs-copy-button\" onclick=\"copy_code('code1', this);\"><i class=\"far fa-copy1\" aria-hidden=\"true\"><\/i><\/button><\/div>\n\n\n<p><strong>Output<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Connected to SQLite\nDeveloper added successfully \n\nMark  joined on 2019-06-28 21:12:35.799206\njoining date type is &lt;class 'str'&gt;\nsqlite connection is closed<\/pre>\n\n\n\n<p>As we can see, we inserted a date object, but when we retrieved the details from a table, we got a string type. But we don&#8217;t want string type. We want the <code>DateTime<\/code> type so we can directly use it.<\/p>\n\n\n\n<p class=\"has-black-color has-text-color has-background\" style=\"background-color:#fff3cd\">To solve this problem, use <code>detect_types<\/code> as <code>PARSE_DECLTYPES<\/code> and <code>PARSE_COLNAMES<\/code> as arguments in the connect method of the sqlite3 module.<\/p>\n\n\n\n<p><strong><code>sqlite3.PARSE_DECLTYPES<\/code><\/strong><\/p>\n\n\n\n<p>If you use this parameter in the connect method, then the sqlite3 module parses the declared type for each column it returns.<\/p>\n\n\n\n<p>It will parse the declared type then use the type converters dictionary to execute the converter function registered for that type there.<\/p>\n\n\n\n<p><strong><code>sqlite3.PARSE_COLNAMES<\/code><\/strong><\/p>\n\n\n\n<p>If you use this parameter in the connect method, then the SQLite interface parses the column name for each column it returns. It will use the converters dictionary and then use the converter function found there to return the value.<\/p>\n\n\n\n<p>Let see the example now. In this example, when we read DateTime from the SQLite table we must get the joining date type as a <code>datetime<\/code>.<\/p>\n\n\n<div class=\"hljstoolbar\"><pre id=\"code2\"  id=\"norun\" class=\"wp-block-code language-python\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"Python\" data-shcb-language-slug=\"python\"><span><code class=\"hljs language-python\"><span class=\"hljs-keyword\">import<\/span> datetime\n<span class=\"hljs-keyword\">import<\/span> sqlite3\n\n<span class=\"hljs-function\"><span class=\"hljs-keyword\">def<\/span> <span class=\"hljs-title\">addDeveloper<\/span><span class=\"hljs-params\">(id, name, joiningDate)<\/span>:<\/span>\n    <span class=\"hljs-keyword\">try<\/span>:\n        sqliteConnection = sqlite3.connect(<span class=\"hljs-string\">'SQLite_Python.db'<\/span>,\n                                           detect_types=sqlite3.PARSE_DECLTYPES |\n                                                        sqlite3.PARSE_COLNAMES)\n        cursor = sqliteConnection.cursor()\n        print(<span class=\"hljs-string\">\"Connected to SQLite\"<\/span>)\n\n        sqlite_create_table_query = <span class=\"hljs-string\">'''CREATE TABLE new_developers (\n                                       id INTEGER PRIMARY KEY,\n                                       name TEXT NOT NULL,\n                                       joiningDate timestamp);'''<\/span>\n\n        cursor = sqliteConnection.cursor()\n        cursor.execute(sqlite_create_table_query)\n\n        <span class=\"hljs-comment\"># insert developer detail<\/span>\n        sqlite_insert_with_param = <span class=\"hljs-string\">\"\"\"INSERT INTO 'new_developers'\n                          ('id', 'name', 'joiningDate') \n                          VALUES (?, ?, ?);\"\"\"<\/span>\n\n        data_tuple = (id, name, joiningDate)\n        cursor.execute(sqlite_insert_with_param, data_tuple)\n        sqliteConnection.commit()\n        print(<span class=\"hljs-string\">\"Developer added successfully \\n\"<\/span>)\n\n        <span class=\"hljs-comment\"># get developer detail<\/span>\n        sqlite_select_query = <span class=\"hljs-string\">\"\"\"SELECT name, joiningDate from new_developers where id = ?\"\"\"<\/span>\n        cursor.execute(sqlite_select_query, (<span class=\"hljs-number\">1<\/span>,))\n        records = cursor.fetchall()\n\n        <span class=\"hljs-keyword\">for<\/span> row <span class=\"hljs-keyword\">in<\/span> records:\n            developer = row&#91;<span class=\"hljs-number\">0<\/span>]\n            joining_Date = row&#91;<span class=\"hljs-number\">1<\/span>]\n            print(developer, <span class=\"hljs-string\">\" joined on\"<\/span>, joiningDate)\n            print(<span class=\"hljs-string\">\"joining date type is\"<\/span>, type(joining_Date))\n\n        cursor.close()\n\n    <span class=\"hljs-keyword\">except<\/span> sqlite3.Error <span class=\"hljs-keyword\">as<\/span> error:\n        print(<span class=\"hljs-string\">\"Error while working with SQLite\"<\/span>, error)\n    <span class=\"hljs-keyword\">finally<\/span>:\n        <span class=\"hljs-keyword\">if<\/span> (sqliteConnection):\n            sqliteConnection.close()\n            print(<span class=\"hljs-string\">\"sqlite connection is closed\"<\/span>)\n\naddDeveloper(<span class=\"hljs-number\">1<\/span>, <span class=\"hljs-string\">'Mark'<\/span>, datetime.datetime.now())\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Python<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">python<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><button class=\"hljs-copy-button\" onclick=\"copy_code('code2', this);\"><i class=\"far fa-copy1\" aria-hidden=\"true\"><\/i><\/button><\/div>\n\n\n<p>Output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Connected to SQLite\nDeveloper added successfully \n\nMark  joined on 2019-06-28 20:57:32.352790\njoining date type is &lt;class 'datetime.datetime'&gt;\nsqlite connection is closed<\/pre>\n\n\n\n<p>As you can see when we retrieved the joining date from SQLite table and we got the result in <code>datetime.datetime<\/code> type.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-next-steps\">Next Steps:<\/h2>\n\n\n\n<p>To practice what you learned in this article, Solve a <a href=\"https:\/\/pynative.com\/python-database-programming-exercise-with-solution\/\">Python SQLite Exercise project<\/a> to practice database operations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This lesson demonstrates how to work with SQLite date and timestamp types in Python and vice-versa. Most of the time, we need to insert Python date or DateTime value into an SQLite table. Also, we need to read the SQLite date and timestamp values stored in the SQLite3 database and convert them into Python date [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[22,23],"tags":[24],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.4 (Yoast SEO v22.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Python SQLite working with DateTime and timestamp<\/title>\n<meta name=\"description\" content=\"Work with SQLite date and timestamp types in Python and vice-versa. Learn how to insert\/Retrieve date and datetime values from SQLite table in Python\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python SQLite working with Date and DateTime\" \/>\n<meta property=\"og:description\" content=\"Work with SQLite date and timestamp types in Python and vice-versa. Learn how to insert\/Retrieve date and datetime values from SQLite table in Python\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/\" \/>\n<meta property=\"og:site_name\" content=\"PYnative\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-28T15:53:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-09T05:27:35+00:00\" \/>\n<meta name=\"author\" content=\"Vishal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@PyNative\" \/>\n<meta name=\"twitter:site\" content=\"@PyNative\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/\"},\"author\":{\"name\":\"Vishal\",\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f\"},\"headline\":\"Python SQLite working with Date and DateTime\",\"datePublished\":\"2019-06-28T15:53:58+00:00\",\"dateModified\":\"2021-03-09T05:27:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/\"},\"wordCount\":444,\"commentCount\":10,\"publisher\":{\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f\"},\"keywords\":[\"Python SQLite\"],\"articleSection\":[\"Python\",\"Python Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/#respond\"]}],\"accessibilityFeature\":[\"tableOfContents\"]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/\",\"url\":\"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/\",\"name\":\"Python SQLite working with DateTime and timestamp\",\"isPartOf\":{\"@id\":\"https:\/\/pynative.com\/#website\"},\"datePublished\":\"2019-06-28T15:53:58+00:00\",\"dateModified\":\"2021-03-09T05:27:35+00:00\",\"description\":\"Work with SQLite date and timestamp types in Python and vice-versa. Learn how to insert\/Retrieve date and datetime values from SQLite table in Python\",\"breadcrumb\":{\"@id\":\"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/pynative.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python\",\"item\":\"https:\/\/pynative.com\/python\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Databases\",\"item\":\"https:\/\/pynative.com\/python\/databases\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Python SQLite working with Date and DateTime\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/pynative.com\/#website\",\"url\":\"https:\/\/pynative.com\/\",\"name\":\"PYnative\",\"description\":\"Python Programming\",\"publisher\":{\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/pynative.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f\",\"name\":\"Vishal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/01\/vishalHule.jpg\",\"contentUrl\":\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/01\/vishalHule.jpg\",\"width\":968,\"height\":1065,\"caption\":\"Vishal\"},\"logo\":{\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/image\/\"},\"description\":\"Founder of PYnative.com. I am a Python developer and I love to write articles to help developers. | All the best for your future Python endeavors!\",\"sameAs\":[\"https:\/\/pynative.com\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Python SQLite working with DateTime and timestamp","description":"Work with SQLite date and timestamp types in Python and vice-versa. Learn how to insert\/Retrieve date and datetime values from SQLite table in Python","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:\/\/pynative.com\/python-sqlite-date-and-datetime\/","og_locale":"en_US","og_type":"article","og_title":"Python SQLite working with Date and DateTime","og_description":"Work with SQLite date and timestamp types in Python and vice-versa. Learn how to insert\/Retrieve date and datetime values from SQLite table in Python","og_url":"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/","og_site_name":"PYnative","article_published_time":"2019-06-28T15:53:58+00:00","article_modified_time":"2021-03-09T05:27:35+00:00","author":"Vishal","twitter_card":"summary_large_image","twitter_creator":"@PyNative","twitter_site":"@PyNative","twitter_misc":{"Written by":"Vishal","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/#article","isPartOf":{"@id":"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/"},"author":{"name":"Vishal","@id":"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f"},"headline":"Python SQLite working with Date and DateTime","datePublished":"2019-06-28T15:53:58+00:00","dateModified":"2021-03-09T05:27:35+00:00","mainEntityOfPage":{"@id":"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/"},"wordCount":444,"commentCount":10,"publisher":{"@id":"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f"},"keywords":["Python SQLite"],"articleSection":["Python","Python Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pynative.com\/python-sqlite-date-and-datetime\/#respond"]}],"accessibilityFeature":["tableOfContents"]},{"@type":"WebPage","@id":"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/","url":"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/","name":"Python SQLite working with DateTime and timestamp","isPartOf":{"@id":"https:\/\/pynative.com\/#website"},"datePublished":"2019-06-28T15:53:58+00:00","dateModified":"2021-03-09T05:27:35+00:00","description":"Work with SQLite date and timestamp types in Python and vice-versa. Learn how to insert\/Retrieve date and datetime values from SQLite table in Python","breadcrumb":{"@id":"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pynative.com\/python-sqlite-date-and-datetime\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/pynative.com\/python-sqlite-date-and-datetime\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pynative.com\/"},{"@type":"ListItem","position":2,"name":"Python","item":"https:\/\/pynative.com\/python\/"},{"@type":"ListItem","position":3,"name":"Databases","item":"https:\/\/pynative.com\/python\/databases\/"},{"@type":"ListItem","position":4,"name":"Python SQLite working with Date and DateTime"}]},{"@type":"WebSite","@id":"https:\/\/pynative.com\/#website","url":"https:\/\/pynative.com\/","name":"PYnative","description":"Python Programming","publisher":{"@id":"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pynative.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f","name":"Vishal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pynative.com\/#\/schema\/person\/image\/","url":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/01\/vishalHule.jpg","contentUrl":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/01\/vishalHule.jpg","width":968,"height":1065,"caption":"Vishal"},"logo":{"@id":"https:\/\/pynative.com\/#\/schema\/person\/image\/"},"description":"Founder of PYnative.com. I am a Python developer and I love to write articles to help developers. | All the best for your future Python endeavors!","sameAs":["https:\/\/pynative.com"]}]}},"featured_image_src":null,"featured_image_src_square":null,"author_info":{"display_name":"Vishal","author_link":"https:\/\/pynative.com\/author\/vishal\/"},"_links":{"self":[{"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/posts\/3883"}],"collection":[{"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/comments?post=3883"}],"version-history":[{"count":0,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/posts\/3883\/revisions"}],"wp:attachment":[{"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/media?parent=3883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/categories?post=3883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/tags?post=3883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}