Menghitung Perbedaan Waktu Antara Dua Tanggal

Menghitung Perbedaan Waktu antara Dua Tanggal

Rumus :

DATEDIFF(datepart,startdate,enddate)

Untuk datepart anda bisa rubah

year
quarter
month
dayofyear
day
week
weekday
hour
minute
second
millisecond
microsecond
nanosecond


contoh  :

SELECT DATEDIFF(day,'2008-06-05','2008-08-05') AS jml_hari

hasilnya = 61 Hari

SELECT DATEDIFF(hour,'2008-06-05','2008-08-05') AS jml_jam

hasilnya = 1464 Jam

Insert select pada SQL Server

Contoh :

select AJH_ID, '20249'  AJD_Emplcode , AJD_LevelCheckID, AJD_Status ,'kusdi' AJD_Username,  getdate() AJD_LastUpdate ,  ajd_checkdetail
from  tm_accessjeisdt
inner join tm_accessjeishd a on AJD_HeaderID=AJH_ID
inner join tbmst_section on ajh_sectioncode=sec_sectioncode
inner join tbmst_employee  on em_emplcode=AJD_Emplcode
where  AJD_Emplcode=20472

kemudian tambahkan didepan select secript insert

Menjadi :

Insert into tm_accessjeisdt (AJD_HeaderID, AJD_Emplcode, AJD_LevelCheckID, AJD_Status , AJD_Username,  AJD_LastUpdate ,  ajd_checkdetail)
select AJH_ID, '20249'  AJD_Emplcode , AJD_LevelCheckID, AJD_Status ,'kusdi' AJD_Username,  getdate() AJD_LastUpdate ,  ajd_checkdetail
from  tm_accessjeisdt
inner join tm_accessjeishd a on AJD_HeaderID=AJH_ID
inner join tbmst_section on ajh_sectioncode=sec_sectioncode
inner join tbmst_employee  on em_emplcode=AJD_Emplcode
where  AJD_Emplcode=20472