Yeah that would seem to work. Or while using SYSDA...
# suiteql
g
Yeah that would seem to work. Or while using SYSDATE:
Copy code
SELECT
	ID,
	TranID,
	Type,
	TranDate
FROM
	Transaction
WHERE
         TranDate >= TO_DATE( TO_CHAR ( SYSDATE, 'DS' ), 'DS' ) 
         AND
         TranDate < TO_DATE( TO_CHAR ( SYSDATE + 1, 'DS' ), 'DS' )