MariaDB 10.3

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

@@version

10.3.9-MariaDB-1:10.3.9+maria~stretch-log

CREATE TABLE `doc_calendars` (
  `date` date NOT NULL,
  `available` tinyint(1) NOT NULL,
  PRIMARY KEY (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `doc_calendars`(`date`, `available`) VALUES ('2018-01-12', 0);
select * from doc_calendars;

date
available

2018-01-12
0

select * from doc_calendars where `date` = '2018-01-12';

date
available

2018-01-12
0

select * from doc_calendars where `date` = '2018-01-12T00:00:00';

date
available

2018-01-12
0

show warnings;
select * from doc_calendars where `date` = '2018-01-12T00:00:00+01:00.000000';

date
available

2018-01-12
0

show warnings;

Level
Code
Message

Warning
1292
Truncated incorrect datetime value: '2018-01-12T00:00:00+01:00.000000'

update doc_calendars set available = 1 where `date` = '2018-01-12T00:00:00';
show warnings;
select * from doc_calendars;

date
available

2018-01-12
1

update doc_calendars set available = 0 where `date` = '2018-01-12T00:00:00+01:00.000000';
show warnings;
select * from doc_calendars;

date
available

2018-01-12
1