i'm trying to select all invoices created today. I tried and transaction.createddate = TO_DATE( TO_CHAR ( SYSDATE , 'DS' ), 'DS' ) and I get nothing but if I do and transaction.createddate >= TO_DATE( TO_CHAR ( it's working. Any idea why >= works and = do not work ?