MySQL 5.7

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

create table test (d datetime, t timestamp)
insert into test values 
(str_to_date('2007-01-01T00:25:47', '%Y-%m-%dT%H:%i:%s'), str_to_date('2007-01-01T00:25:47', '%Y-%m-%dT%H:%i:%s')),
(replace('2007-01-01T00:25:47', 'T', ' '),replace('2007-01-01T00:25:47', 'T', ' '))
select * from test


d
t


2007-01-01 00:25:47
2007-01-01 00:25:47

2007-01-01 00:25:47
2007-01-01 00:25:47

d	t
2007-01-01 00:25:47	2007-01-01 00:25:47
2007-01-01 00:25:47	2007-01-01 00:25:47