SQLite for Beginners: Dates

preview_player
Показать описание
SQLite doesn't have date and time datatypes, which begs the question, how do you deal with your date and time values?

Want to learn more? Check out this video.

  1. Mycelial
Рекомендации по теме
SQLite for Beginners: 0:07:01

SQLite for Beginners: Dates

How to Use 0:14:47

How to Use Dates in SQLite

SQLite Datetime functions 0:05:54

SQLite Datetime functions part 1

SQL : How 0:00:59

SQL : How do I insert datetime value into a SQLite database?

SQLite for beginners: 0:08:38

SQLite for beginners: Datatypes

SQLite - Date 0:02:59

SQLite - Date and time

SQL : how 0:00:54

SQL : how to query in sqlite for different date format

SQLite For Beginners: 0:16:06

SQLite For Beginners: Journal Modes

Python SQLite Remembering 0:09:40

Python SQLite Remembering Things From Digital Memory Using DATETIME | #55 (SQLite #5)

How to Store 0:03:49

How to Store and Sort Dates in SQLite: Integer vs. Text Format?

SQL : SQLite 0:01:20

SQL : SQLite database - select the data between two dates?

sqlite is my 0:12:25

sqlite is my favorite database (beginner - intermediate) anthony explains #500

SQL : How 0:01:20

SQL : How to add time to a dateTime in sqlite?

SQLite Date & 0:03:06

SQLite Date & Time Functions

Delete a record 0:00:29

Delete a record from SQLite database WHERE datetime contains date from variable (1 answer)

How to Fix 0:02:28

How to Fix sqlite3.InterfaceError When Inserting Date and Time in SQLite

Working with Dates 0:05:43

Working with Dates in SQLite Using PHP PDO | Date Functions Explained

SQLite for beginners: 0:06:44

SQLite for beginners: JSON

Built-in functions in 0:32:43

Built-in functions in Sqlite (Date and string functions)

Databases: Sqlite date 0:01:35

Databases: Sqlite date issue (2 Solutions!!)

Android : How 0:01:17

Android : How to add date in sqlite database

How to Convert 0:03:48

How to Convert a String to Date in SQLite

How to Format 0:01:37

How to Format Dates in SQLite: Transforming m/d/Y Hr:Min:Sec to Y-m-d

How to Convert 0:01:28

How to Convert a String to Date in SQLite

Комментарии
Автор

Your tutorials on sqlite are the best! Very well-explained and pragmatic. Thank you!

CameronFlint
Автор

If you're wondering what the hell is going on when he inserted a string into a real column, and even retrieved it again... Sqlite doesn't care about column definitions. It will happily store any type into any column, regardless of its definition. You can store strings into int columns, sqlite will not complain. It also ignores columns lengths, like "varchar(20)". You can store a 100 character string into that column, no problem. Learn about "type affinity" for more info.

GerbenWijnja
Автор

So which one would you recommend? Specifically for created_at, updated_at?

CanRau