-
Notifications
You must be signed in to change notification settings - Fork 0
Home
ajaytani edited this page Jul 11, 2017
·
1 revision
Welcome to the python wiki!
(FLOOR((DT_I4) (DATEDIFF("ss", @[System::StartTime] , GETDATE()))/3600)==0?"":
(DT_WSTR, 4) (FLOOR((DT_I4) (DATEDIFF("ss", @[System::StartTime] , GETDATE()))/3600)) +" Hrs, " )+
((FLOOR((DT_I4) (DATEDIFF("ss", @[System::StartTime] , GETDATE()))/60)%60)==0?"":
(DT_WSTR, 4) (FLOOR((DT_I4) (DATEDIFF("ss", @[System::StartTime] , GETDATE()))/60)%60) + " Mins, ") + (DT_WSTR, 4) ((DT_I4) (DATEDIFF("ss", @[System::StartTime] , GETDATE() ) )%60) + " Secs"