DATA BASE PARKIR

drop table PARKIR cascade constraint;

create table PARKIR(
no_polisi char(8),
waktu_masuk char(8),
waktu_keluar char(8));

insert into PARKIR
values('B6235FSD','08:08:22','11:20:45');
insert into PARKIR
values('B6123FDF','08:40:21','13:32:45');
insert into PARKIR
values('B6754DSD','09:44:44','12:47:45');
insert into PARKIR
values('B6556NMS','11:51:05','15:44:43');
insert into PARKIR
values('B617SFS','09:56:31','15:41:13');
insert into PARKIR
values('B6778PRF','08:41:58','13:51:40');
insert into PARKIR
values('B6654GDG','13:57:21','16:21:12');

select * from PARKIR;



select no_polisi,substr(waktu_masuk,1,2) as JM,substr(waktu_masuk,4,2) as MM,
substr(waktu_masuk,7,2) as DM,substr(waktu_keluar,1,2) as JK,substr(waktu_keluar,4,2) as MK,
substr(waktu_keluar,7,2) as DK,((substr(waktu_keluar,1,2)*3600)+(substr(waktu_keluar,4,2)*60)+(substr(waktu_keluar,7,2)))

-((substr(waktu_masuk,1,2)*3600)+(substr(waktu_masuk,4,2)*60)+(substr(waktu_masuk,7,2))) as Lama_parkir from PARKIR;