If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

sysdate value

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?