Monday, 2 September 2013

how to find starting time after the break

how to find starting time after the break

create table timetable2 (office_start_time datetime,office_end_time
datetime, first_break_start_time datetime,first__break_end_time datetime,
office_start2_time datetime,office_start2_end_time datetime,
second_break_start_time datetime,second_break_end_time datetime,
employee_od_start_time datetime,employee_od_job_time datetime )
insert into timetable2 values('2013-09-02 08:00:31.773','2013-09-02
12:00:31.773', '2013-09-02 11:00:31.773','2013-09-02 11:30:31.773',
'2013-09-02 12:00:31.773','2013-09-02 18:00:31.773', '2013-09-02
15:30:31.773','2013-09-02 16:00:31.773', '2013-09-02
09:00:31.773','2013-09-02 10:00:31.773')
Result will be 8.00,10.00,11.30,16.00

No comments:

Post a Comment