By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 2 Duplicates: 0 Warnings: 0
Records: 2 Duplicates: 0 Warnings: 0
id | emp_id | sign_time | end_time | diff_month1 | diff_month | diff_minute1 | diff_minute |
---|---|---|---|---|---|---|---|
25 | 83 | 2018-11-21 00:00:00 | 2018-12-01 15:27:00 | 0 | equal | 1808 | greater |
26 | 94 | 2018-11-21 00:00:00 | 2018-12-01 15:23:00 | 0 | equal | 1804 | greater |
id | emp_id | sign_time | end_time | diff_month1 | diff_month | diff_minute1 | diff_minute |
---|