SQLite 3.39

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

create table test(created_at text);
✓
insert into test values 
  ('2021-02-14 6:37:00'), 
  ('2021-02-14 06:37:00'), 
  ('2021-02-05 3:35:00'), 
  ('2021-02-05 03:35:00'), 
  ('2021-01-28 8:21:00'),
  ('2021-01-28 08:21:00') 
  ;
✓
select created_at, 
       strftime('%Y', created_at) yr, 
       strftime('%m', created_at) mth 
from test


created_at
yr
mth


2021-02-14 6:37:00
null
null

2021-02-14 06:37:00
2021
02

2021-02-05 3:35:00
null
null

2021-02-05 03:35:00
2021
02

2021-01-28 8:21:00
null
null

2021-01-28 08:21:00
2021
01

created_at	yr	mth
2021-02-14 6:37:00	null	null
2021-02-14 06:37:00	2021	02
2021-02-05 3:35:00	null	null
2021-02-05 03:35:00	2021	02
2021-01-28 8:21:00	null	null
2021-01-28 08:21:00	2021	01