SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table something
(
  some_number integer, 
  some_date date, 
  very_strange some_type_that_stores_my_data,
  column_with_no_type
)
insert into something
values
(1, '2021-21-22', 'foobar', 'bla')
select *
from something


some_number
some_date
very_strange
column_with_no_type


1
2021-21-22
foobar
bla


insert into something
values
('fourty-two', 42, 46, 50);
select *
from something;


some_number
some_date
very_strange
column_with_no_type


1
2021-21-22
foobar
bla

fourty-two
42
46
50


update something
   set some_date ='021-12-23 08:14:15'
 where some_date = 42;
select *
from something;


some_number
some_date
very_strange
column_with_no_type


1
2021-21-22
foobar
bla

fourty-two
021-12-23 08:14:15
46
50


update something
   set some_date ='2'||some_date
 where some_date = '021-12-23 08:14:15';
select *
from something;


some_number
some_date
very_strange
column_with_no_type


1
2021-21-22
foobar
bla

fourty-two
2021-12-23 08:14:15
46
50