Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT h.ID, h.SUB_ID
- FROM history h
- WHERE 1=1
- AND h.SUB_ID = :subId
- AND (
- 1=1
- AND (
- TO_DATE(:startDate, 'YYYY-MM-DD HH24:MI:SS') >= h.VALIDFROM
- AND TO_DATE(:startDate, 'YYYY-MM-DD HH24:MI:SS') <= NVL(h.VALIDUNTIL,sysdate)
- ) OR (
- TO_DATE(:startDate, 'YYYY-MM-DD HH24:MI:SS') <= h.VALIDFROM
- AND TO_DATE(:endDate, 'YYYY-MM-DD HH24:MI:SS') >= NVL(h.VALIDUNTIL,sysdate)
- ) OR (
- TO_DATE(:endDate, 'YYYY-MM-DD HH24:MI:SS') >= h.VALIDFROM
- AND TO_DATE(:endDate, 'YYYY-MM-DD HH24:MI:SS') <= NVL(h.VALIDUNTIL,sysdate)
- )
- )
- $query = $this->db->prepare($query);
- $query->bindValue('subId', 20180101123456789, PDO::PARAM_STR);
- $query->bindValue('startDate', $validFrom->format('Y-m-d H:i:s'), PDO::PARAM_STR);
- $query->bindValue('endDate', $validUntil->format('Y-m-d H:i:s'), PDO::PARAM_STR);
- $query->execute();
- $result = $query->fetchAll();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement