Ugh, disregarded my own pet peeve with TO_DATE/TO_...
# suiteql
g
Ugh, disregarded my own pet peeve with TO_DATE/TO_CHAR combos. Haha
Copy code
SELECT
	ID,
	TranID,
	Type,
	TranDate
FROM
	Transaction
WHERE
         TranDate >= TRUNC(SYSDATE)
         AND
         TranDate < TRUNC(SYSDATE + 1)