-
Notifications
You must be signed in to change notification settings - Fork 0
/
logs.txt
35 lines (21 loc) · 2.16 KB
/
logs.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
---- 11/03/2016 11:32:33 AM ----
SELECT *, DATE_FORMAT(`LivCredDateFrom`, '%Y-%m-%d') AS LivCredDateFrom, DATE_FORMAT(`LivCredDateTo`, '%Y-%m-%d') AS LivCredDateTo FROM `tblempleavecredits` WHERE `EmpID` = '93009' AND `LivCredDateFrom` LIKE '2016%' ORDER BY `LivCredDateTo` ASC;
-------------- end -------------
---- 11/21/2016 09:28:25 AM ----
SELECT *, DATE_FORMAT(`LivCredDateFrom`, '%Y-%m-%d') AS LivCredDateFrom, DATE_FORMAT(`LivCredDateTo`, '%Y-%m-%d') AS LivCredDateTo FROM `tblempleavecredits` WHERE `EmpID` = '82156' AND `LivCredDateFrom` LIKE '2016%' ORDER BY `LivCredDateTo` ASC;
-------------- end -------------
---- 11/21/2016 09:45:12 AM ----
SELECT *, DATE_FORMAT(`LivCredDateFrom`, '%Y-%m-%d') AS LivCredDateFrom, DATE_FORMAT(`LivCredDateTo`, '%Y-%m-%d') AS LivCredDateTo FROM `tblempleavecredits` WHERE `EmpID` = '93009' AND `LivCredDateFrom` LIKE '2016%' ORDER BY `LivCredDateTo` ASC;
-------------- end -------------
---- 12/05/2016 02:15:50 PM ----
SELECT *, DATE_FORMAT(`LivCredDateFrom`, '%Y-%m-%d') AS LivCredDateFrom, DATE_FORMAT(`LivCredDateTo`, '%Y-%m-%d') AS LivCredDateTo FROM `tblempleavecredits` WHERE `EmpID` = '93009' AND `LivCredDateFrom` LIKE '2016%' ORDER BY `LivCredDateTo` ASC;
-------------- end -------------
---- 12/05/2016 02:15:52 PM ----
SELECT *, DATE_FORMAT(`LivCredDateFrom`, '%Y-%m-%d') AS LivCredDateFrom, DATE_FORMAT(`LivCredDateTo`, '%Y-%m-%d') AS LivCredDateTo FROM `tblempleavecredits` WHERE `EmpID` = '93009' AND `LivCredDateFrom` LIKE '2016%' ORDER BY `LivCredDateTo` ASC;
-------------- end -------------
---- 12/05/2016 02:16:05 PM ----
SELECT *, DATE_FORMAT(`LivCredDateFrom`, '%Y-%m-%d') AS LivCredDateFrom, DATE_FORMAT(`LivCredDateTo`, '%Y-%m-%d') AS LivCredDateTo FROM `tblempleavecredits` WHERE `EmpID` = '93009' AND `LivCredDateFrom` LIKE '2016%' ORDER BY `LivCredDateTo` ASC;
-------------- end -------------
---- 12/05/2016 02:16:10 PM ----
SELECT *, DATE_FORMAT(`LivCredDateFrom`, '%Y-%m-%d') AS LivCredDateFrom, DATE_FORMAT(`LivCredDateTo`, '%Y-%m-%d') AS LivCredDateTo FROM `tblempleavecredits` WHERE `EmpID` = '93009' AND `LivCredDateFrom` LIKE '2016%' ORDER BY `LivCredDateTo` ASC;
-------------- end -------------