SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t1
(
  id         "Any Number type",
  something  some_magic_type,
  another    "Don't Know"
)
insert into t1 values 
(1, 42, 'Foo'), 
(2, '10:30', 'Bar'), 
("three", 'value', "foo");

3 rows affected


select * 
from t1


id
something
another


1
42
Foo

2
10:30
Bar

three
value
foo


create table t2
(
  id,
  something,
  another
)
insert into t2 values 
(1, 42, 'Foo'), 
(2, '10:30', 'Bar'), 
("three", 'value', "foo");

3 rows affected


select * 
from t2


id
something
another


1
42
Foo

2
10:30
Bar

three
value
foo


create table t3
(
  id         integer,
  something  date
)
insert into t3 (id, something)
values 
(1, '2022-01-01'),
('fourty two', 'last friday')

2 rows affected


select *
from t3


id
something


1
2022-01-01

fourty two
last friday