SQLize Online / PHPize Online  /  SQLtest Online

Create table Logins(user_id int, time_stamp DATETIME); insert into Logins (user_id, time_stamp) values ('6', TO_DATE('2020-06-30 15:06:07', 'yyyy-mm-dd HH24:MI:ss')); insert into Logins (user_id, time_stamp) values ('6', TO_DATE('2021-04-21 14:06:06', 'yyyy-mm-dd HH24:MI:ss')); insert into Logins (user_id, time_stamp) values ('6', TO_DATE('2019-03-07 00:18:15', 'yyyy-mm-dd HH24:MI:ss')); insert into Logins (user_id, time_stamp) values ('8', TO_DATE('2020-02-01 05:10:53', 'yyyy-mm-dd HH24:MI:ss')); insert into Logins (user_id, time_stamp) values ('8', TO_DATE('2020-12-30 00:46:50', 'yyyy-mm-dd HH24:MI:ss')); insert into Logins (user_id, time_stamp) values ('2', TO_DATE('2020-01-16 02:49:50', 'yyyy-mm-dd HH24:MI:ss')); insert into Logins (user_id, time_stamp) values ('2', TO_DATE('2019-08-25 07:59:08', 'yyyy-mm-dd HH24:MI:ss')); insert into Logins (user_id, time_stamp) values ('14', TO_DATE('2019-07-14 09:00:00', 'yyyy-mm-dd HH24:MI:ss')); insert into Logins (user_id, time_stamp) values ('14', TO_DATE('2021-01-06 11:59:59', 'yyyy-mm-dd HH24:MI:ss')); SELECT * FROM Logins;