MySQL 5.7

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

select version();


version()


5.7.39


CREATE TABLE user (
   id INT NOT NULL AUTO_INCREMENT,
   name VARCHAR(100) NOT NULL,
   department VARCHAR(100) NOT NULL,
   submission_date DATETIME,
   PRIMARY KEY ( id )
);
INSERT INTO user
(name,department,submission_date)
SELECT 'ABC','department',convert_tz('2021-11-30 05:57:00', '+00:00', '-05:00');

Records: 1  Duplicates: 0  Warnings: 0


select * from user


id
name
department
submission_date


1
ABC
department
2021-11-30 00:57:00