I have a table that has a field called effdt. When a user makes a change to the data in the table it creates a new row with the new data and an effdt of when the knew data is effective. I want to write a statement that is part of a program that runs automattically, and selects all rows in the table when the effdt is equall to todays date, where todays date will always be changing. I thought I would say select * from table where effdt = sysdate. That doesn't work because sysdate gives me month day year, and time. Effdt only has month day year so it returns no rows. How can I get just the month day year?