Pycharm Database for SQlite converts date and datetime columns to long integers

link之家

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

神勇威武的豆浆 · 图说科学城教育篇· 1 月前 ·

重感情的丝瓜 · 【推文】万人迷渣受‖人人都爱周知青_哔哩哔哩 ...· 1 月前 ·

活泼的奔马 · 西班牙皇家足球协会_百度百科· 4 月前 ·

悲伤的熊猫 · 经验 | ...· 10 月前 ·

痴情的拖把 · 《王者制造》：一个文明社会始终难以解决的难题 ...· 1 年前 ·

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

According to the issue on the JetBrains issue board, this seems to be a common problem. But can be solved by setting the date_class in the SQLite driver.

In the " Database " tool window, open the Data Source properties window " Data Sources and Drivers " and select the tab " Drivers " > the entry " SQLite " > tab " Advanced " > Set date_class to value TEXT .

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question . Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers .

推荐文章

神勇威武的豆浆 · 图说科学城教育篇

1 月前

重感情的丝瓜 · 【推文】万人迷渣受‖人人都爱周知青_哔哩哔哩_bilibili

1 月前

活泼的奔马 · 西班牙皇家足球协会_百度百科

4 月前

悲伤的熊猫 · 经验 | 北大心理347跨考专业课（下）-CSDN博客

10 月前

痴情的拖把 · 《王者制造》：一个文明社会始终难以解决的难题 - 知乎

1 年前