SQLite 3.27

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

create table type_test
(
  int_col int,
  date_col date, 
  real_col real
);
✓
insert into type_test
values ('one', 'last year this time', 'forty two')
✓
select *
from type_test


int_col
date_col
real_col


one
last year this time
forty two